Registered aircraft · 250

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

N8640EGrimes Flying Lab Foundation · Urbana, OHS/N AF-510 N868LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N A-173 N8720RMorrison Neil E · Port Townsend, WABuilt 1958 · S/N 52-10681 N87690Montana Sitework LLC · Rainbow City, ALS/N AF-528 N87692Hill Vincent T · Bucyrus, KSBuilt 1952 · S/N AF-619 N876NSteeves Brian G · Wahpeton, NDS/N 52-10876N N87711Planeview Aviation Services Inc · Ahoskie, NCS/N BA-650 N8934MLance Toland Ltd · Griffin, GABuilt 1964 · S/N BA-664 N897SBCascade Airways LLC · Jefferson, ORBuilt 1958 · S/N BA-385 N9030BShe Said Yes LLC · Verona, ILBuilt 1962 · S/N BA-641 N90460Mitchell Aircraft Components Inc · Borrego Springs, CABuilt 1958 · S/N A-937 N90502Glover William Scott · Mt Pleasant, TXBuilt 1947 · S/N A-346 N90552Aeropacific Corp · Idaho Falls, IDBuilt 1948 · S/N A-420 N90628Deductionpros LLC · Longview, TXS/N A-809 N908Heinze Gregory L · Little Rock, ARBuilt 1945 · S/N A-36 N909GPRegistered aircraftBuilt 1957 · S/N BA-236 N90TTTwin Beech Partners LLC · Virginia Beach, VABuilt 1957 · S/N BA-335 N912KKEllis Ronald G · N Fort Myers, FLS/N AF-426 N9157ZDakota Express LLC · Wilmington, DES/N AF-884 N9172ZNighthawk Air Systems Inc · Palmetto Bay, FLS/N AF-604 N924JRegistered aircraftS/N BA-163 N92756Dakota Express LLC · Wilmington, DEBuilt 1965 · S/N BA-728 N929DVSiegfried Rand W · Sausalito, CABuilt 1954 · S/N BA-32 N92WAAdamson Donald R · Lonoke, ARBuilt 1958 · S/N BA-379 N930RGarrett David B · Polson, MTBuilt 1959 · S/N BA-438 N933GMMartin Jonathan W · West Grove, PAS/N BA-533 N9370ZHans Boat Works Inc · Visalia, CABuilt 1954 · S/N 52-10850 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 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 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 72-16-02 R3