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.
N2712DBlackwood R John Trustee · Salinas, CAN2712SKelly Matthew Raymond · New Florence, MON2713AAlpha Enterprises Inc · Lercester, NCN2713DBlack Mountain Flying Service Ltd · Boulder City, NVN2713LFlemmer Richard W · Park City, MTN2713UAeronetica LLC · Tulsa, OKN27143Olson James A · Hixton, WIN2714DDeane Gregory H · Anacortes, WAN2714HRey Thomas A · Fort Worth, TXN2714JRegistered aircraftN2715CHead Nyle C · Sisters, ORN2715DEducation Connection LLC · Port Saint Lucie, FLN2715HGregory Vernon L · Swansea, SCN2715LGoebel Christian E · Luray, VAN2715NSaxon Thaddeus K · Daytona Beach, FLN2715UBelle Fourche Flight Center LLC · Belle Fourche, SDN2716DDammann Willa B · Murrieta, CAN2716SWright Herbert L · Vickery, OHN2717CGibboney Scott H · Temecula, CAN2717DGrimsley Steve K · Underhill, VTN2717SMartin Tyler · Pompano Beach, FLN2717URasmussen Raleigh C · Seattle, WAN2718DCongdons Aviation Service · Anchorage, AKN2718SBurroughs David G · El Paso, ILN2718UBondurant Ross · Eugene, ORN2719DRaber Michael R · Xenia, OHFirst renewal noticeN2719JDewey Robert P · Ramona, CAN2719UVilches Armando L · Brentwood, TNN271DTuckerman Kurt W · Branford, FLN271HRegistered aircraftN271REEigsti Rodney E Trustee · Friend, NEN271RMMartinson Ryan D · Nome, AKN2720DHill Sheldon S · Minot, NDN2720LBaalman Gary E · San Jose, CAN2721JDe Aviation Inc · La Porte, TXN2721KTibbitts Constance B · Marble Canyon, AZN2721SPeyton Investments LLC · Washington, NCN2722CHavener Walter J · Lodge Grass, MTN2722DFly South Aviation LLC · Little Rock, ARN2722KN2722k LLC · Austin, TXN2722LSmolik Amanda · Northlake, TXN2723DBarnes Jeffrey L · Odessa, TXN2723LJkr7 LLC · The Dalles, ORN2723NTrahan John · Lebanon, ORN2724CN2724c LLC · Levering, MIN2724DRojas Conrad · Fairbanks, AKN2724NF F Enterprises · Hadley, MNN2724UGarner Harry W · Le Roy, NYN2725JQuinn Timothy · Bountiful, UTN2725LFulenchek Raymond D · Sherman, TX
Back to AD 94-05-05 R1