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.

N623FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816131 N6240HLouisa Air LLC · Louisa, VAS/N 28-7890220 N6242CFlight School 101 LLC · Winter Haven, FLBuilt 1978 · S/N 28-7816399 N6247JInternational Air Services Inc Trustee · Carson City, NVS/N 28-7690380 N6248CFort Leavenworth Flying Club · Fort Leavenworth, KSS/N 28-7816629 N624AQHigh Flight Academy LLC · Allison Park, PABuilt 1984 · S/N 28-8416122 N624CJJones Steven Clark · Flagler Beach, FLBuilt 2020 · S/N 2881427 N624FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916446 N6250CShields Ray Winfrey III · Marietta, GAS/N 28-7890357 N6254JCoast Flight Training And Management Inc · San Diego, CABuilt 1976 · S/N 28-7690383 N6256CKing David M · Plainville, CTBuilt 1978 · S/N 28R-7837154 N625BBBig Bend Community College · Moses Lake, WABuilt 2023 · S/N 2881694 N625FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842130 N625NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881161 N6269CBorck Benjamin · Bala Cynwyd, PABuilt 1978 · S/N 28-7816402 N626BPBroburg Gregory W · Minneapolis, MNBuilt 1977 · S/N 28-7790552 N626CPPenn Flight Academy LLC · Quakertown, PABuilt 1979 · S/N 28-7990396 N626MAJefferson City Aviation Inc · Jefferson City, MOBuilt 1996 · S/N 28-43026 N6270JGabel Douglas L · Hillsboro, ORBuilt 1976 · S/N 28-7690387 N6271JG&M Aircraft Inc · Wheat Ridge, COS/N 28-7690388 N627AAPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 2881627 N627BBPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010045 N627FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842131 N6281CMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7816403 N6287JAdil Junaid · Tucson, AZBuilt 1976 · S/N 28-7690392 N6288JIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7690393 N628FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842124 N6293JClear Horizon Holdings LLC · Cheyenne, WYBuilt 1976 · S/N 28-7690395 N6294CB A R C Asset Management LLC · Boynton Beach, FLBuilt 1978 · S/N 28-7890358 N6297JYale Aviation Inc · New Haven, CTBuilt 1976 · S/N 28-7690394 N629FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842132 N629NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881148 N629NFSunstarr Aviation LLC · Fond Du Lac, WIS/N 28-7790431 N6301CMustang Aviation LLC · Orleans, NEBuilt 1978 · S/N 28-7890359 N6304CHarben LLC · Albemarle, NCBuilt 1978 · S/N 28R-7837155 N630HCDgsz Aero Inc · Bear, DEBuilt 1980 · S/N 28-8090268 N630KTLetourneau Duane R · Oconto, WIBuilt 2000 · S/N 28-43397 N630RJHovan Robert G · Port Orange, FLBuilt 1979 · S/N 28-7916503 N6312CLibra Air Inc · Las Vegas, NVBuilt 1978 · S/N 28-7816405 N6313CShouling & Philip Enterprise · Lancaster, CABuilt 1978 · S/N 28-7816406 N6319CNew York Aviators LLC · South Ozone Park, NYBuilt 1978 · S/N 28-7890362 N631FTFlorida Institute Of Technology · Melbourne, FLBuilt 1981 · S/N 28-8216036 N631NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881166 N631PCPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020282 N6320CHeme Flying LLC · Lewisville, NCBuilt 1978 · S/N 28R-7837157 N632NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881153 N632SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881433 N6331CLambert James Donald · Sterling, COBuilt 1978 · S/N 28-7816408 N6334CPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7816409 N6341CD & D Design & Manufacturing Inc · Wheatland, OKBuilt 1978 · S/N 28-7816411

Back to AD 2016-07-21