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.
N8004XSchriever Rebecca M · Lees Summit, MON8005AWalker Aviation LLC · Big Timber, MTN8005SFletcher Michael A · Vancouver, WAN8006LGmdg LLC · Shreveport, LAN8006SBering Capital LLC · Anchorage, AKN8007SGolden Aerial Services LLC · Erie, PAN80082Madden Ronald · Bronx, NYN80085Holmes Robert T · Vale, ORN8008BNeill James H · Keller, TXN8008TRichardson Ronnie L · East Wenatchee, WAN8009AMiles Austin B · Bend, ORN8009BTaber Floyd K · Osceola, IAN8009FRucinski Edward A · Climax, NCN800BNesta Richard V · Mansfield, OHN800HEFredericks Kenneth L · Halliday, NDN800PYBigge George F Jr · Pittsgrove, NJN800SWBalciunas Algimantas Trustee · El Dorado, CAN800UDSpence Vincent A · Memphis, TNN800ZECurcio Matthew L · Irvine, CAN8010ATaylor Michael A · Pipestone, MNN8010FTorres Mora Jose Alberto · Modesto, CAN8010LLegion Flying Club Inc · Springfield, MAN8011LLaska Lonny J · Tonawanda, NYN8011TDykstra Wayne A · Pipestone, MNN8012FHood William T · Columbia, SCN8012SCollins Scott · Upland, CAN8012XSingh Joga · Auburn, WAN8013ATrade Winds Aviation Holdings LLC · Lewes, DEN8013LCarroll Connie S · Clyde, TXN8013SRedmond Angela L · Austin, TXN8014AMcdaniel Leigh W · Orland, CAN8014BHeinrich George F Jr · Hastings, MNN8014SMurray Bart · Pacifica, CAN8015FLewis L Dwight Jr · Lopez Island, WAN8016APak Holdings LLC · Anchorage, AKN8017ABue Brian G · Palmer, AKN8017LOgle Randall W · Wenatchee, WAN8017SHughes Todd R · Rocky Ford, CON8017XCaudill Jimmy L · Grove, OKN8018AConley Ronald Dean Trustee · Lamoille, NVN8019AOlson Kenneth L · Raymond, WAN8019BColonial Air Inc · New Bedford, MAN8019FLyman Kenneth R · Livermore Falls, MEN8019LSleeping Giant Flying Club Inc · Helena, MTN8019XWarren Edwin W · East Dorset, VTN801BLiem Daniel L · Brea, CAN801CCPogey Aviation LLC · Fort Pierce, FLN801JFWarbird Leasing LLC · Santa Fe, NMN801TFLundquist Larry E · De Smet, SDN8020AOakleaf Dan L · Hartford, SD
Back to AD 94-05-05 R1