AD 94-05-05 R1
Registered aircraft · 26,231
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.
N5452TEagle Sky Patrol Inc · Deadwood, SDN5453CHead Laverne E · Ozark, ALN5453HSturdivant Charles R · Littleton, CON5453RVaughn Mark R · Fort Payne, ALN5454QPetko James · Mishawaka, INN5454TPearce David W Trustee · Anchorage, AKN5455CSnurkowski John V · Laurens, NYN5455FHoye Charlie L · Rimrock, AZN5455REpstein Paul · Pensacola, FLN5455TStrickland Justin Ryan · Lovington, NMN5456TKelley Keith B · Forney, TXN5457CWidewings LLC · Alexandria, VAN5457FWehrly Phoenix O · Elbow Lake, MNN5457RFarrand David V · London, OHN5458FMorgan Scott E · Allen, NEN5458RLafranchise Louis C · Aurora, ORN5458TTodd Tyler L · Quitman, MSN5459CWatkins George T · Spokane Valley, WAN5459FDavis James A · Astoria, ORN5459JKling Aviation Inc · Friendswood, TXN5459QZimmerman Dean F · Royalton, MNN5459RAllsup Rachel B · Anchorage, AKN5459TBrennan Brian L · Tipton, IAN545LWiebe James R · Valley Center, KSN5460HStrange William H · Lewiston, IDFirst renewal noticeN5460QJacobson Eric R · Ouray, CON5460RTake Angels Aviation LLC · Watertown, NYN5461FMeade Larry G · Tallahassee, FLN5462HReddig Dean E · Lustre, MTN5462RJameson Fred · Rathdrum, IDN5463TFrazier Isaiah V · Blue River, WIN5464CKlockner Charles R · Waterford, WIN5464FTiger Flight Foundation Inc · Rome, GAN5464QBinsfeld Thomas · Chico, CAN5464TJackson Tyler H · Kittery, MEN5465COliphant Donald E · Benbrook, TXN5465QWhitford John T · South Weber, UTN5465RHaffley And Ruiz LLC · Waco, TXN5466CLewis Elijah J · Luthersville, GAN5466HStone Leonard J · Oshkosh, WIN5466QDe Sciscio Salvatore A · Chaplin, CTN5466THildebrant Virginia Fay · Fall City, WAN54677Squire Edward C · Newport, NYN5467RCarter Roy T · Shepherdsville, KYN5467TRegistered aircraftN546ABElder Robert C · Prosser, WAFirst renewal noticeN546CPAustin Cody R · Pflugerville, TXN5470QBuiqui Aerospace Corp · Kissimmee, FLNon-citizen corporation, flight hours not reportedN5470TLesnick Robert E · Charlotte, NCN5471QGunnarsson Jon · Concrete, WA
Back to AD 94-05-05 R1