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.
N8834UHudson Valley Aviation LLC · Campbell Hall, NYN8834XRegistration Pending · Shawnee, OKRegistration pendingN8835GNelson Joel B · Alliance, OHN8835SWinchester Holdings LLC · Monticello, MNN8835XBechtel Jerold L · Snover, MIN8835ZMaloney Eric T · Houston, DEN8836UWhite Charles A · Rch Palos Vrd, CAN8837TSimon Jevon D · Buckley, WAN8837XRichards Kevin J · Magnolia, TXN8838BMason City Enterprises LLC · Mason City, NEN8838XAdventist World Aviation Inc · Wilson, NCN8838ZG2g Aviation LLC · Wray, CON8839BRiberio Trucking LLC · Stratford, CTN8839GRegistered aircraftN8839TKansas Farm And Ranch Inc · Seneca, KSN8839USchuh Thomas M · Queen Creek, AZN8839XAlexander Ray J · Battle Ground, WAN8839ZCole Samuel L M III · Kenai, AKN883CMDelone Charles · Sarasota, FLN883CPCivil Air Patrol · Maxwell Afb, ALN883DDKelly David C II · Roseville, CAN883EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN8840SBlue Thunder Aviation LLC · Heath Springs, SCN8840TNelson William J · Hamilton, MTN8840UHathor Aviation LLC · Johnstown, CON8840XSb Enterprise LLC · Marshall, TXN8841BErwin Brandon · Jacksboro, TXN8841GLinn Parker J · Brainerd, MNN8841UNorcal Flight Center LLC · Lincoln, CAN8841XAngelone Inc · Elkhart, INN8842GTiller Stanford C · Loup City, NEN8842TMcnamee Michael P · Anthony, NMN8842UHwa LLC · Charleston, SCN8843BBaker Ralph · Lake Geneva, FLN8843GSanders Don · Mustang, OKN8843TDiscovery Medical Research LLC · Kearney, NEN8843UGullatt Jamey D · Mount Airy, NCN8843XDavis James S · Reno, NVN8844GNorthside Logistics And Automotive Inc · Dardanelle, ARN8844XMangum Larry M · Morristown, TNN8844ZTerry L Fowler LLC · Greenbrier, ARN8845BB1rd Flying LLC · Hotchkiss, CON8845KVan Bortel Aircraft Inc · Arlington, TXN8845QJohnson James W · Wilmot, ARN8845THeaton James D · Cuba, MON8845XByerly Charles W · Joliet, MTN8845ZCartwright Adam C · Homestead, FLFirst renewal noticeN8846TN8846t LLC · Canyon, TXN8846USmith Chad · Boulder City, NVN8847BSeymour John R · Findlay, OH
Back to AD 79-10-14 R1