Registered aircraft · 275

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

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:75-27-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2') ORDER BY n_number

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:75-27-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2')
  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:75-27-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2')
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.

N9375YNord Aviation Inc · Santa Teresa, NMBuilt 1960 · S/N BA-564 N94HD U Aircraft Leasing Inc · Green Bay, WIS/N A-33 N9539Jones James M Jr · Monroe, LABuilt 1952 · S/N CA241 N9540Hardin Donald R · Saint Helena, CABuilt 1952 · S/N CA-244 N9549ZNighthawk Air Systems Inc · Palmetto Bay, FLS/N AF727 N9550ZQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N AF-586 N9551ZJurgens Charles T · North Pole, AKS/N 51-11660 N9560Sale Reported · Rexburg, IDSale reported, canceledS/N 51269 N95CXIsland City Seaplanes Inc · Cordova, AKS/N BA-319 N9604RBohl Howard M · Temecula, CABuilt 1959 · S/N BA-464 N9621RTwin Beech G18s LLC · Galt, CABuilt 1959 · S/N BA-471 N96240Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N CA-159 N9669NLoudakis George · Stuart, FLBuilt 1958 · S/N BA-382 N9669REngram Matt · Branson, MOS/N BA-495 N9690RDove Enterprises LLC · Wilmington, DEBuilt 1960 · S/N BA-494 N97001Mod Air LLC · Peyton, COS/N 51121 N9772ZCity Of Marshall · Marshall, MIS/N AF-575 N9840ZMcdaniel Peter · Urbana, ILBuilt 1960 · S/N AF-886 N985SJohnston Thomas · Wasilla, AKBuilt 1959 · S/N BA-476 N9889Z3g Classic Aviation Inc · Wilmington, DES/N AF-805 N9918RHochhaus Andrew · Norfolk, VABuilt 1960 · S/N BA-521 N99799Vocell James J · Moultonborough, NHBuilt 1969 · S/N BA-758 N99800Rugged Investments One LLC · North Miami, FLBuilt 1969 · S/N BA-759 N9NKNighthawk Air Systems Inc · Palmetto Bay, FLS/N AF-505 N9WMJespersen Aircraft Services Inc · Bettles Field, AKS/N AF-637

Back to AD 75-27-09 R2