AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N9142TLjungkvist Kristian · Ashland, ORN91430N91430 LLC · San Antonio, TXN91439Mod Flying LLC · Elkhorn, NEN9143ACacka David A · Klamath Falls, ORN9143USherer Preston A · Watertown, WIN9144BMason Matthew L · Lincoln, ILN9144GZimmerman Paul B · Haswell, CON9144MRobertson James D · Liberty, MON9144XWinsome Ag Services LLC · Johnson, KSN91451Pettus Const Inc · Dallas, GAN9145AWomack Wilbur A Jr · Jackson, LAN9145GYost James J · Placentia, CAN9145USharp Wayne H · Mena, ARN91464Breard Armand C · Monroe, LAN9146AHusser Marilyn G · Independence, ORN9146GShea Bernie J · Polson, MTN9146MJc Aircraft Leasing LLC · Wasilla, AKN9146XMangun Charles L · Middleton, IDN91470Sky Sailing Inc · Warner Springs, CAN91475Johnson Robert L · Douglas, AKN91476Petersen Greg · Chelan, WAN9147BReed Zane · Mountain Home, IDN9147CCope Eric E · Angels Camp, CAN9147GSnyder Barry L · Morrison, CON91484Scovel Simeon Edwin · Ontario, CAN91489Dan River Aero Club Inc · Jonesville, NCN9148MBlackhole Inc · Round Rock, TXN9149BFoust Kal E · Lenox, MIN9149MBoynton Scott E · Campbell Hall, NYN914AVNorcal Skydiving LLC · Cloverdale, CAN914AZN969az LLC · Miami, FLN914CBChan Blair H · Arlington, TXN914EYDreimiller Raymond J Jr · Bloomfield, NYN914FCSinibaldi Glenn · Highland Park, NJN914HSHis Wings Air Service Inc · Hyder, AKN914JBSwartz Eric C Trustee · Aptos, CAN914JDAis Wings LLC · Grand Rapids, MIN914MDCrum Brian B · Warrensburg, MON914RLNichols Charles C · Hanford, CAN914RRMartinez Jeff L · Lewistown, MTN914SCHotel Aviation LLC · Oregon City, ORN914STAir Ex LLC · Chelan, WAN914SWSilver Express Co DBA · Miami, FLN914ZSkylens LLC · Hammond, LAN91507Eagle Aviation LLC · Spearfish, SDN91508Stewart Bryan P · Carson City, NVN91509Watts Timothy R · Hermiston, ORN9150BHarral Blake · Prescott Valley, AZFirst renewal noticeN9150CAkers Joel W · Anchorage, AKN9150HN9150h LLC · Charleston, SC
Back to AD 79-10-14 R1