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.
N89816Redman Ronald G · Palouse, WAN89818Benning Dennis D · Tuolumne, CAN89829Ficker Duane · Marine, ILN89830Doda Scott R · Niagara, WIN89833Shaffer Randall H · Orinda, CAN89835Ramras Jay B · Fairbanks, AKN89836Barr Michael J · Colorado Springs, CON89837Williams Robert W Jr · Lees Summit, MON8983BMcguire Zach T · Jasper, MON89842Welch James D · Holdenville, OKN89844Stevens Brian R · Lompoc, CAN89848Haas David C · Janesville, WIN89849Myers Russell · Spangle, WAN8984BWhelchel Neil E · Joshua Tree, CAN89850Thompson Michael P · Natchez, MSN89855Jones Riley T · Thayne, WYN89858Livingston Patrick A · Pratt, KSN8985RChapman William H · Dayton, OHN8985SOrganization Of Black Aerospace Professionals · Westchester, ILN8986Fisher William G · Union City, GAN89860Bradley Charles R · Herod, ILFirst renewal noticeN89861Hicks Bobby J · Horn Lake, MSN8986SSchneider Jackson L · Florissant, MON8986UJmt Aviation LLC · Bel Air, MDN8987BHoover Rowdy L · Owasso, OKN89882Plane Fun Inc Tr Trustee · Snellville, GAN89883Beck Christopher A · Belvidere, ILN89884Valiair Lc Trustee · Casper, WYN89885Erhart Aviation Services LLC · Kalispell, MTN89886Dickson David C · Sebring, FLN8988UQuestair LLC · Madison, MSN89895Gandall Ryan D · Elk, CAN89898Fay Gregory A · Milton, VTN89903Covey Zachary J · New Underwood, SDN89906Beery Ray M · Exeter, CAN89907Hill David A · Fort Worth, TXN8990BSortomme Jeffrey P · Sacramento, CAN89911Krause Aviation LLC · Geneva, ILN89918Christie Ian A H · Limon, CON89923Livermont Joann M · Dillingham, AKN89925Dirigo Aerospace Solutions LLC · Sumner, MEN89932Swartzendruber Brett · Hesston, KSN89936Barnes Clint R · Wills Point, TXN89938Nickel Galen L · Sagle, IDN8993SRopp Dale Arden · Bemidji, MNN89941Bernard E Fay II · Eagle, AKN89942Hawgwild Aviation & Holdings LLC · Kansas City, MON89947Christain Keith · Ogden, UTN8994SMorel Charles Paul IV · Morgan Hill, CAN8994UWahlberg Randy A · Pearland, TX
Back to AD 94-05-05 R1