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.

N31649Runway Hero LLC · Wayland, MABuilt 1978 · S/N 28R-7837241 N31669Navy Annapolis Flight Center Inc · Edgewater, MDBuilt 1978 · S/N 28-7816574 N31694Rey Al · Burlington, NCBuilt 1978 · S/N 28R-7837244 N316ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881641 N31715Brereton Mark C · Lineville, ALBuilt 1978 · S/N 28-7816578 N31716Metro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816579 N31734Oscar Air LLC · Bethlehem, PABuilt 1978 · S/N 28R-7837246 N3173QRosner Gary A · Enfield, CTBuilt 1977 · S/N 28-7716140 N31754Idlewild Aviation Inc · Lewes, DEBuilt 1978 · S/N 28-7890478 N3175QMarshaltown Aviation Inc · Marshalltown, IABuilt 1977 · S/N 28-7716141 N317BFBoldflight LLC · Greenwood, INBuilt 1979 · S/N 28-7990428 N317TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020141 N31831Dcoat LLC · Greenlawn, NYBuilt 1978 · S/N 28-7890479 N31863Dell Air Co LLC · Paterson, NJBuilt 1978 · S/N 28-7890482 N3187QJuliet Whiskey Aviation LLC · Gilbert, AZBuilt 1977 · S/N 28-7790441 N3189QBoll Weevil Flyers LLC · Reedville, VABuilt 1977 · S/N 28R-7737049 N31900Woodward Joseph A Jr · Wshngtn Xing, PABuilt 1978 · S/N 28-7816592 N31905Weishuhn Aviation LLC · Farwell, MIBuilt 1978 · S/N 28-7890484 N31906Bosveld Bobby J · Markesan, WIBuilt 1978 · S/N 28R-7837254 N31923Metro Aicraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816597 N31926Van Cura Don · Chicago, ILBuilt 1978 · S/N 28-7890486 N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259 N31969Chandelle Flying Club Inc. · Austin, TXBuilt 1978 · S/N 28-7890488 N31970Benefield John H Jr · Cedartown, GABuilt 1978 · S/N 28R-7837260 N31985Ledge Aero Inc · Holt, MIBuilt 1978 · S/N 28-7816604 N31988Little Dog Aviation LLC · Branchburg, NJBuilt 1978 · S/N 28-7816605 N319CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881505 N319EGVertx Fleet Holdings LLC · San Diego, CABuilt 2021 · S/N 28020021 N319FTPerez Guillermo T · Castaic, CABuilt 1982 · S/N 28-8216208 N31LHUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816236 N31VUJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 2844179 N320NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881618 N320UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020227 N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541 N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545 N322EFRkm Aviation · Lexington, NCBuilt 2021 · S/N 28020031 N322NDUn Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881749 N3230QArizona Cassidy E · North Platte, NEBuilt 1977 · S/N 28-7790448 N3238QAttitude And Configuration Indicator LLC · Bedford, TXBuilt 1977 · S/N 28-7716145 N323DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843827 N323NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881619 N3252QArcher Inc · South Ozone Park, NYBuilt 1977 · S/N 28-7790446 N325AVSilver City Flying Club Inc · New Hartford, CTBuilt 1979 · S/N 28-7990346 N325TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020189 N326CCMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881575 N326RHHerrlin Rodney C · East Hampton, NYBuilt 1979 · S/N 28-8090145

Back to AD 2016-07-21