Registered aircraft · 19

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

N126HKStockton Field Aviation Museum · Stockton, CABuilt 1944 · S/N 44-35788 N167BTina Fly Inc Trustee · Wilmington, DEBuilt 1944 · S/N 44-34602 N240PAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1941 · S/N 7140 N26BKMid America Flight Museum · Mount Pleasant, TXS/N 28045 N26PJPremier Jets Inc · Hillsboro, ORBuilt 1944 · S/N 28987 N26RPTsi Holdco Inc · Virginia Beach, VABuilt 1956 · S/N 6874 N26VQContinental Aviation Inc · Kingsford, MIBuilt 1941 · S/N 41-39486 N34538Martin Aviation Inc · Santa Ana, CAS/N 27817 N4313Kubrak Maciej · North Hollywood, CABuilt 1944 · S/N 44-34313 N4959KAbrams Airborne Manufacturing Inc · Tucson, AZS/N 44-34749 N4988NReynolds James Stanley · Haltom City, TXS/N 64-17679 N500MRComanche Warbirds Inc · Houston, TXBuilt 1945 · S/N 28048 N5544VSly Duane D DBA · Platte, SDBuilt 1944 · S/N 44-35552 N5625SEagleton Wade C · Bakersfield, CAS/N 44-35456 N6840DSpirit Of North Carolina LLC · Virginia Beach, VABuilt 1945 · S/N 29190 N706MEOn Mark Engineering LLC · Fairbanks, AKBuilt 1944 · S/N 27992 N7079GAlien Invaders LLC · Medina, WABuilt 1944 · S/N 28841 N74874Jz Aero Montana LLC · Missoula, MTBuilt 1944 · S/N 44-34508R N9990ZMilitary Aircraft Restoration Corp · Costa Mesa, CABuilt 1943 · S/N 43-22602

Back to AD 47-36-01