AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N831TYTyndall William A · Live Oak, FLN83200Rbj Ranchwest LLC · Elroy, WIN8320TMoeller Channing T · Huntsville, ALN8320XHagovsky Thomas C · Attica, INN8321BSkyhawk18 LLC · Opa Locka, FLN8321GSilveria Clifford J · Humble, TXN8321UBoss Bradley J · Clarksville, TNN8322AFlack James R Trustee · Loudonville, OHN8322HWickizer Larry S · Harrisburg, ORN8322JMiller Patrick · Riverside, CAN8322UBurkett Kevin H · Portland, TXN8323GRusso Dobye G · Clinton, OKN8323HWestern Antique Aeroplane & Automobile Museum · Hood River, ORN8323JKc Eagles Soaring Club · Gardner, KSN8323MBean Danny O · Mulkeytown, ILN8323UFortman Steven W · Minneapolis, MNN8323XHumpage Jason H · Eugene, ORN83244Howe Mark E · Lake Stevens, WAN83248Search And Rescue Inc · Swatara, MNN83249Trieber Steven M · Casa Grande, AZN8324BVitt Steven · Lecanto, FLN8324GDexter Brady R · Chambers, NEN8324MKnox John D · Broken Arrow, OKN8324XJohnson Scott A · Missoula, MTN8325ASutton Aircraft Salvage LLC · Palmer, AKN8325BDeckard Leroy Jr · Waller, TXN8326ARacoon Aviation LLC · San Antonio, TXN8326UHill John R · Seattle, WAN8326XFlores Thomas E · Balch Springs, TXN83277Bessett Daniel · Lowell, ORN8327JSaunders Grant J · Sebring, FLN8327MArch Frederick W Jr · Lake Placid, FLN8327TMatson Donald Jr · Lake Stevens, WAN8327XTwo Seven Xray LLC · Paradise Valley, AZN8328BMontpelier Gary L · W Chazy, NYN8328JTreat James · Batesville, ARN8328MLuker Victor R Jr · Terrell, TXN8328XPrevatt Richard T · Jacksonville, FLN83295Steffey Charles S · Raleigh, NCN8329A170 Adventures LLC · Hermosa Beach, CAN8329HLarose Timothy · Sebastopol, CAN8329JWooley Eva · Hephzibah, GAN8329UVolkman Ary D · Waunakee, WIN832ETTowe Elbert S · Madison, ALN832PWatson Bobby · Hoxie, ARN832SRWallace John M · Canton, MSN83300Dennis John Mark L · Paola, KSN8330AKoliadko Joseph I · Luray, VAN8330TPerry Charlotte A · Pearland, TXN83317Hughes Michael C · Wasilla, AK
Back to AD 94-05-05 R1