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.
N96575Biryukov Ruslan B · Encino, CAN96579Civil Air Patrol Inc · Maxwell Afb, ALN9657GAirmates Flying Club Inc · Northfield, NJN9657VChorman Spraying LLC · Milton, DEN96583Inconceivable LLC · Wilmington, DEN9658AMouser Jay F · Goldendale, WAN9658XSale Reported · Ozark, ALSale reportedN96590Simple Air LLC · Ankeny, IAN96594Logbook Lift Inc · Monroe, LAN96598Hawkins Curtis F · Monette, ARN9659HJd Griffin LLC · Wilmington, DEN9659QMacrafic Bruce A · Garden City, MNN9659VAitken Lyle W · Tuscaloosa, ALN965AUAuburn University · Auburn University, ALN965BBBascom Kimber Keith · Mckinney, TXN965CPCivil Air Patrol · Maxwell Afb, ALN965CWAir Capital Aviators Club · Wichita, KSN965EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN965LTUniversity Of La System DBA · Ruston, LAN965MMBastian Devan · Vernal, UTN965MSMt San Antonio College · Walnut, CAN965SCoverdale Mark E · Folsom, CAN96602Hofer Galen J · Denver, CON96607Bailey Joe D · Trophy Club, TXN9660AYates Michael H · Darlington, MDN9660BHenry Lawrence D · Lohman, MON9660HCdb Group Holdings LLC · Sheridan, WYN9660XDodson International Parts Inc · Rantoul, KSN96616Air Transport Inc DBA · Las Vegas, NVN9661AEndsley Larry R · Waynesboro, VAN9661BKennemer Vaughn · Carter, OKN9661GAvco Patrol LLC · Lyndon, KSN9661TSiebe James E · Moscow, IDN9661XMangan Communications Inc · Bastrop, TXN96621D Gordon Aviation Inc · La Jolla, CAN96626Wingsleasing LLC · Wichita, KSN96628Bobby Nelson Aviation LLC · Kettering, OHN9662QHomiller Robert S · Bear, DEN9662VLevel X Aviation LLC · Royal Palm Beach, FLN9662XMacdonald Kaitlyn A · Dillon, MTN96634Standefer Wayne B · Highland Village, TXN96639Ringel John S · Long Beach, CAN96642Bingham Ned R · Redmond, WAN9664KUsda Aphis Ppq · Edinburg, TXN9664TKalebaugh Todd C · Lostine, ORN96654Mcgahey Timothy P · Mccall, IDN9665BMilligan Reid D · Catawba, NCN9665HDouble Bridges Aviation LLC · Enterprise, ALN9665QAlldredge Aviation · Auburn, WAN9665TFlight Tech Inc · Arlington, WA
Back to AD 79-10-14 R1