AD 94-05-05 R1
Registered aircraft · 26,232
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.
N704HFNo Name Aviation LLC · Wilmington, DEN704HGAvery Ricky E · Redfield, SDN704HKChilstrom John S · Austin, TXN704HRLitcof Brian P · Moultonborough, NHN704HYStatter Daniel E · Chicago, ILN704JCAskenasy George R · Cleburne, TXN704JFHammer Joseph W Jr · Shannon, ILN704JHPhelps Clay DBA · Santa Paula, CAN704JKWardle Lynn A · Rogue River, ORN704JLSprecher Susan E · Locust Grove, GAN704JQRusso Robert J · Hope Valley, RIN704JRAirgo Inc · Centralia, ILN704JSCassels William · Phoenix, AZN704JVVan Zyl Larry D Trustee · Sherwood Forest, CAN704JXSchwettmann Dennis E · Nampa, IDN704KAMartin Noah I · Brookeville, MDN704KDSmith Kenneth E Jr · Collinsville, OKN704KHCampbell Bruce A · Henderson, NVN704KPMassari John C · Wantage, NJN704KQJones Gary L · Athens, GAN704KREagle Aeroplane LLC · Delano, TNN704KSFlying Ace LLC · Lakeville, MNN704KUHoelscher Mark A · Richmond, INN704KVArellano Eric · Harlingen, TXN704KXBain Joshua L · Watauga, TXN704LASoutheastern Oklahoma State University · Durant, OKN704LCEdwards Pacific Aviation Corp · Dover, DEN704LFSable Douglas B · Petersburg, VAN704LGMunger Christopher M · Watertown, MAN704LJLepp Jason E · Butterfield, MNN704LKGreen Daryl Keith · Grove City, OHN704LPRother Michael V · Granbury, TXN704LRTcm Flying Club Inc · Mobile, ALN704LVBrock George W · Union, MON704MGStephens Brian A · Bruceville, INN704MHOrmond Aircaft Leasing & Management Inc · Ormond Beach, FLN704MKPerez Sigfredo A · Fort Buchanan, PRN704MQGriffin Shawn · Locust Grove, GAN704MTAirways Aviation Services LLC · Miami, FLN704MUJones K L III · Jasper, ALN704NCShaw Paul W · Pecos, TXN704NKRebel Aviation Inc · Liberty, MON704NLJ&J Aeronautics LLC · Houston, TXN704NQAllard Yoshimi · Carmel, CAN704NWVan Warmerdam Les C · Nampa, IDN704PCJeff Air Pilot Services LLC · Shelbyville, INN704PDSale Reported · Peachtree City, GASale reportedN704PFBlackburn Andrew J · Rome, GAN704PHDeters Isaac John · Preston, MNN704PKArg Management - Clemson Blvd LLC · Sandy Springs, SC
Back to AD 94-05-05 R1