AD 94-05-05 R1
Registered aircraft · 26,231
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N3545GObrien A Scott · Santa Rosa Valley, CAN3545SMaldonado Edward R · Independence, ORN3545TSantamaria Joseph J · Hebron, NHN3545VSoaring Pinions LLC · Rittman, OHN35463Vajdos Robert C Jr · Louise, TXN3546JFerguson David G · Candler, NCN3546SJackson Harry Jason · El Centro, CAN35476Sauer Michael A · Wahpeton, NDN3547SThhm LLC · Menomonie, WIN3548GWild Animal Sanctuary · Keenesburg, CON3548HGresley Ross A · Catawba, NCN3549CTappen Paul W · Delta Junction, AKN3549GPlumb Ray A · Salida, CON3549SSchott Roy W · Derby, KSN3549TBosse Lilou A · Anchorage, AKN3549WRegistration Pending · Falls Church, VARegistration pendingN35503Windham Jack B Jr · Elba, ALN3550CScott Mark A · Anchorage, AKN3550HShinn Larry J · Victor, CAN3550JHanson Parry B · Eagle Creek, ORN3551JCox Capital LLC · Rushville, MON3551SStraub Brian Trustee · Columbus, OHN3551TPlummer Deborah L · Houston, AKN3551VPrince John C III · Frierson, LAN35523Taylor Rachel N · Big Lake, AKN35535Goodman Michael K · Brooksville, FLN35536Pueblo Historical Aircraft Society · Pueblo, CON35539Chastain John A · Lyons, KSN3553CSavage Christopher H · Senaeca, SCN3553GCronsell Kenneth L · Hampshire, ILN3553LDulce Vida Property Consultants LLC · Denver, NCN3553NLiberty Leasing LLC · Melbourne, FLN3554CHubert Pulley Car Sales Inc · Havelock, NCN3554GIler Elden · Van Nuys, CAN3554JEsposito Jason C · Melbourne, FLN3554SWeisser Steve · Milford, INN3554VHayes Kenneth L · Blue Ridge, VAN3555Josi Michael · Conifer, CON3555HStuckle Eugene A · Davenport, WAN3555JMason Wiley B · Woodbury, TNFirst renewal noticeN3555TGoodwin Peter · Spring Hill, TNN3555VJohnson Peter L · Chico, CAN3556DMarookian James R · Annandale, NJN3556KFairweather Flying Service LLC · Juneau, AKN3556LBurrows Brian A · Argyle, TXN3556SLakeland Aviation Of Minocqua Inc · Arbor Vitae, WIN3556TJulicher Mark R · Bulverde, TXN3557JHannah Lonnie · Williamson, WVN3557LStauffer Tom · Renton, WAN3557SWagner Joel D · Anchorage, AK
Back to AD 94-05-05 R1