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.
N8356HBolton Warren S Jr · Niles, MIN8356MSporie George F · Marinette, WIN8356UKolb Austin R · Phoenixville, PAN8357AMcclellan Richard G · Poplar Grove, ILN8357BHarker James P · Blaine, MNN8357KBaldasaro Bonnie B · Clifton Park, NYN8358JMorrow John E · Clarendon, TXN8358TTbs Aviation LLC · Wilmington, DEN8358UN8358u LLC · Knoxville, IAN83591Felling Benjamin C · Barrett, MNN8359AWoosley Kenneth D · Rumsey, KYN8359JManchester Eric S · Milton, VTN8359TCornejo Bernard J · Elko, NVN8359UMusgrove Stacy J · Cunningham, TXN83600Studer Pat · Shelby, MIN8360MOld Goat Aviation LLC · Naples, FLN8360UHead Joseph · Fairbanks, AKN8360XJk Sparks Inc · Lutz, FLN8361ABenton Paul N · Manhattan, KSN8361BBrim Robert H · Bellingham, WAN8361JCoughlin Kevin P · Ridge, NYN8361UBoss Gary W · Bronston, KYN8362BDelp Ryan K · Southbury, CTN8362UJohnson Scott T · Delta, UTN8362XMarlow Haley C · Carrollton, MSN83632Moody James W · Alexandria, LAN83635Registration Pending · Little Rock, ARRegistration pendingN83639Payne Jan T · Glenwood, MNN8363URagsdale Gregory · Peoria, AZN8363XKrause Alex E · Oklahoma City, OKN8364BDigiacomo Ernest R · Hampton Bays, NYN8364MComchoc Paul R · Bellevue, WAN8364UElite Fleet Jacksonville LLC · Jacksonville, FLN8365AHauptman George J · Halfway, ORN8365BHallada David M · Lakeview, MIN8365GMendez Carlos L · Somerset, NJN8365UHunt Ellwood M · Texarkana, TXN83667Johnson Harvey P · Roseau, MNN8366ACyr Gregory A · Augusta, MEN8366GRovers Adrian J · Chazy, NYN8366JRobertson R Topp · Decatur, TXN8366MMccauley Aviation Inc · Springfield, TNN8366TPoint Garrett Robert · Wilmington, NCN8366UHob Aero Inc · Freeland, MIN8366XAjm Aviation Ventures LLC · Seal Beach, CAN83673Everson Harold E · Granville, NDFirst renewal noticeN8367AAnderson Arthur L · Fitzgerald, GAN8367BPrudek Daniel M · Rathdrum, IDFirst renewal noticeN8367GRangesh Abinand · Newton, MAN8367MConner Jacob P · Kaplan, LA
Back to AD 94-05-05 R1