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.
N4638EMorelock Colleen P Trustee · Beavercreek, OHN4638FSkydive Lake Tahoe LLC · Tahoe City, CAN4638KWiggins Air Patrol LLC · Wichita, KSN4638XHoward David R · Oconomowoc, WIN46390Gerber Aviation LLC · Winter Haven, FLN46391Stark Rickie N · Princeton, MNN46392Tedron Air Ltd · Setauket, NYN46396Kpa LLC · Kalamazoo, MIN46399Rutter Clarence W III Trustee · Norman, OKN4639BMoncrief Georgeanne H Trustee · Nampa, IDN4639CHansman Robert J · Cambridge, MAN4639KMyers Gary L Trustee · Onida, SDN4639LHalle Michael P · Livingston, TXN4639QGrundmann Karl · Manassas, VAN4639XCjs Aviation Consulting LLC · Phoenix, AZN463AGAb Prop Plane II LLC · Metairie, LAN463CACivil Air Patrol · Maxwell Afb, ALN463CMUniversity Of Central Missouri · Warrensburg, MON463MAnssec LLC · Lake In The Hills, ILN463PWDunlop Ronald K · Scottsdale, AZN463SPRegistered aircraftN463TWTom Wood Aviation Inc · Fishers, INN46401Bandstra Larry J · Heath Springs, SCN46404Coastal Fliers Inc · El Cajon, CAN46407Solis Joseph G · Poulsbo, WAN4640EState Of Utah · Salt Lake City, UTN4640FDouglas Mark S DBA · Bellingham, WAN4640J4 Flyers Inc · Norwood, NYN4640KLarson Family Farms LLC · Haxtun, CON4640XStern Roger A · Kearny, AZN46410Valentine Terence · Glennallen, AKN46415Hage Michael J · The Villages, FLN46418Batesquire LLC · Clanton, ALN46419Rodgers Bruce W · Ramona, CAN4641BKey James M · Hermiston, ORN4641CKirchoff Kevin B · Rosemark, TNN4641LRegistration Pending · El Reno, OKRegistration pendingN4641QFitzsimons Nicholas T · Covington, LAN46420Frontier Environmental Solutions Inc · Inyokern, CAN46423Parrish Aviation Flight Academy LLC · Southlake, TXN4642BRegister Edmond A · Tyler, TXN4642LJordan Jason A · Portland, MEN4642UHolt John William · Tucson, AZFirst renewal noticeN46430J & Dk LLC · Overland Park, KSN46433Plummer Fred C · Normal, ILN46435Hawkins County Sports Wings Inc · Kingsport, TNN46436Aero Science International LLC · Martinez, GAN46437Arizona Active Air LLC · Yuma, AZN4643BAnderson Charles D · Fairbanks, AKN4643XTaylor Aaron B · Leander, KY
Back to AD 79-10-14 R1