Skip to content

Registered aircraft · 5,443

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

N36281Hedgehog Management LLC · Salem, OHBuilt 1978 · S/N 28-7890503 N36282Beverly Flight Center LLC · Danvers, MABuilt 1978 · S/N 28R-7837271 N362JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 2843158 N362MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881589 N362NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881656 N36304Capital Aviation II LLC · Bethesda, MDBuilt 1978 · S/N 28-7890504 N36355Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816630 N36358Hans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7816631 N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277 N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633 N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634 N363MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881653 N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511 N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636 N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514 N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516 N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518 N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519 N364AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881990 N364MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881654 N364ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881645 N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520 N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521 N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513 N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522 N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284 N36583Trident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7816647 N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320 N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688 N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671 N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672 N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673 N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286 N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129 N366CACavorite Aviation LLC · Lehi, UTBuilt 1998 · S/N 2843135 N366MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881689 N36700Archuleta Jeffrey Michael · Abilene, TXBuilt 1978 · S/N 28-7890526 N36711N36711 Piper LLC · Provo, UTS/N 28-7890527 N36749Air Smt LLC · Powell, OHBuilt 1978 · S/N 28R-7837291 N36777Litwin Linda J · Potomac, MDBuilt 1978 · S/N 28R-7837292 N36789Paschke Jay · Weatherford, TXBuilt 1978 · S/N 28-7890530 N367MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881746 N36800Fly Aviation Corp · Wilmington, DEBuilt 1978 · S/N 28-7816658 N36802United States Air Force- Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837293 N36804Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 28R-7837295 N36838Sapphire Air LLC · Keystone, COBuilt 1978 · S/N 28R-7837296 N368MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881776 N368PLCti Aircraft Leasing LLC · Memphis, TNS/N 2881296 N368RTBaldhill Flying Partners Llp · Binford, NDBuilt 1978 · S/N 28-7890531 N368ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881646

Back to AD 2016-07-21