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.
N3531LLihs Austin R · Sioux City, IAN3531VLunsford Ronald E · Marion, NCN3532DUreneck Paul M · Gray, MEN3532VMause Kenneth M · Sunray, TXN3533CWestern North Carolina Air Museum · Hendersonville, NCN3533SDalton Joseph D · Circleville, UTN3533VRegistration Pending · Brunswick, GARegistration pendingN3534CHausback Brian Trustee · Sacramento, CAN3534DWamsley Clayton O · Trimble, MON3534GSchrock Michael L · Felton, DEN3534VJervis Joseph · Genoa, WVN3535BLohrstorfer Matthew K · Anchorage, AKN3535DGreene Bryan V · Turlock, CAN3535GJandreau Ronald R · Fort Kent, MEN3535JRegistered aircraftN3535KWorm Gary L · Adona, ARN3535LToy Donald R · Homestead, IAN3535VProulx Paul M · Marshall, VAN35366Hatz Judith L · Wausau, WIN3536DRush Ray A · Palmer, AKN3536ELindgren Darrell Allen · Wasilla, AKN3536LPnw Sky Trekking LLC · Colville, WAN3536VSantiago James J · Mountain Lakes, NJN3537DGross Thomas E · Mooresville, NCN3538DConrad Daniel Robert · Sweet Home, ORN3538JConnect With Aviation LLC · Everett, WAN3539JSainer George F · Fort Worth, TXN3539LCummings Kenneth · Camano Island, WAN3539NCj And Sons Aircraft Club · Wilmington, DEFirst renewal noticeN353JKAirspeed Marketing LLC · Phoenix, AZN353PDOnstott Kimberly L · Burkburnett, TXN353WFlight Path Ra LLC · North Miami, FLN35400Aero Maintenance Inc · Vancouver, WAN3540DHardwick James Anthony · Pasadena, CAN3540VPearson Victor E · Lake Stevens, WAN3541TWolcott Kent E · Colorado Springs, CON3542CRobertson Braxton Cecil · Selma, NCN3542GBibb Henry Q Jr · Durham, NCN3542SKing Theresa Ann · Bakersfield, CAN3543Jaws Air LLC · Gainesville, FLN3543CMock Lurita M · Anderson, INN3543JRegistration Pending · Bridgeport, PARegistration pending, pending cancellationN3543LPeaster David · Brunswick, GAN3543NOnstep LLC · Ann Arbor, MIN3543TSmithwick Robert A · Palmer, AKN35448Moreau Raymond L · Slidell, LAN3544CAryana Arash · Livermore, CAN3544STucker Nicholas · Sebastopol, CAN3544TSnyder Thomas E · Anchorage, AKN3544VNormandy Flyers Limited Inc · Middletown, DE
Back to AD 94-05-05 R1