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.
N9006CMillionista Investment Hub LLC · Boca Raton, FLN9006GAltomari Richard J · Pittsburgh, PAN9006MHolliday Dean Trustee Et Al · Klamath Falls, ORN9007AWeiszmann Erik · Bedford, NHN9007GKem Air Enterprises LLC · Kalispell, MTN9007JMalcolm Douglas B · Shell Beach, CAN9007MKirkman Robert Nolan · Pilot Mountain, NCN9007XGustafson Stephen M · Tallulah, LAN9008CFogleman Brian L · Stonewall, LAN9008HTextron Aviation Employees Flying Club Inc · Wichita, KSN9008MWhaley Steven Todd · De Leon Springs, FLN9009CKyer Barry Patrick · Honey Grove, TXN9009HConnell Flying Service Inc · Decorah, IAN9009TNelson Landon E · Monument, CON9009XChick Theodore D DBA · Beulah, NDN900CAAtp Aircraft 1 LLC · Wilmington, DEN900DFWaters Aero-Marine Inc · South Thomaston, MEN900EDSpradling James · Fremont, OHN900HPKansas Highway Patrol · Topeka, KSN900JBPumpkin Eater LLC · Tavares, FLN900MPSweet Fred A · Loves Park, ILN900RPCobra Aviation Services LLC · San Angelo, TXN900RSInmon Leon C · Williston, FLN900RTTakle Raymond L · Hudson, WIN900SCCordle Christopher T · Howard, OHN9010KMitchell Richard · Voorhees, NJN9010MCrotts Aircraft Service Inc · Dodge City, KSN9011Kro Bros LLC · Lebanon, OHN9011AWilmsen Paul R · Millington, ILN9011XCowan James H · New Springfield, OHN9012CClark Gloria L Trustee · Gillette, WYN9012GCockrell Carroll G · Mount Sterling, KYN9012HLeading Edge Flight Academy LLC · Bend, ORN9012MMutchler Joseph T · Billings, MTN9012XGone Flying LLC · Bartlesville, OKN9013CMarch David H · Lincoln, CAN9013TLamb Aaron C · Vail, AZN9013XSpooner Brian P · Poway, CAN9014HFlex Air Holdings Inc · Manhattan, KSN9014MAvery John W · Fergus Falls, MNN9014XSudoh Kenji · Duluth, MNN9016CLindblom Carl O · Saxon, WIN9016GSkydive Duluth Superior LLC · Superior, WIN9016MKinslow Aviation LLC · Prague, OKN9016TDiaz Mark Adba · Madera, CAN9016XWolfe John G · Tooele, UTN9017HMeece Harvey T · Somerset, KYN9017TCombs Ryan W · Carson City, NVN9018AGodbold Robert L · Apex, NCN9018GSimpkins Lynn DBA · Costa Mesa, CA
Back to AD 79-10-14 R1