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.

N3575UJ P Aviation LLC · Kingfisher, OKBuilt 1979 · S/N 28-8090198 N3575XSmith Foster Fritz · Bishopville, SCBuilt 1979 · S/N 28-8090199 N3576HJohnson Grant J · Doylestown, PABuilt 1979 · S/N 28-8090205 N3576JStephens Lloyd G · Saratoga, CABuilt 1979 · S/N 28-8090206 N3576MFly Legacy Planes LLC · Philadelphia, PABuilt 1978 · S/N 28-7890315 N3576RDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1979 · S/N 28-8090207 N35789Barrett Robin C · Holwaloa, HIBuilt 1979 · S/N 28-8016230 N357BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881912 N357JAEagle Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020077 N357MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881523 N357PPaphos Airways LLC · Farmingdale, NYBuilt 1977 · S/N 28-7816005 N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126 N358BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881806 N358CAFreeman Braxton L · West Lebanon, NHBuilt 1989 · S/N 2841283 N358GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881428 N358MKNorth Star Aviation · Mankato, MNBuilt 2022 · S/N 2881524 N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858 N359BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881807 N359FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020059 N359NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881658 N35PABorzoya Aero Group Inc · Slatington, PABuilt 1977 · S/N 28-7716087 N35WCHawley Flying Club Inc · Fargo, NDBuilt 1979 · S/N 28-8016180 N36024Walla Walla University · College Place, WABuilt 1978 · S/N 28R-7837262 N36052Icarus Flying Academy LLC · Farmingdale, NYBuilt 1978 · S/N 28-7816608 N36056Cleared Aviation LLC · Novato, CABuilt 1978 · S/N 28-7816609 N3606MStuart B Stephens Dds Ms Plc · Yukon, OKBuilt 1978 · S/N 28-7890277 N36077Coffey Diane L · Chuckey, TNBuilt 1978 · S/N 28-7890492 N3608MRoman Peter A · Aurora, ILBuilt 1978 · S/N 28-7816359 N36094Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1978 · S/N 28-7816612 N36095Wiese Robert M · Washburn, NDBuilt 1978 · S/N 28-7890494 N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265 N3609MKosbruk Patrick E · Perryville, AKBuilt 1978 · S/N 28-7816360 N360BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2025 · S/N 2881913 N360FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020060 N36115Turner Randall D · Tolar, TXBuilt 1978 · S/N 28-7816613 N36116Meriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816614 N36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeBuilt 1978 · S/N 28-7890495 N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266 N36134Manning John W · Floyds Knobs, INBuilt 1978 · S/N 28-7816615 N36167James Brett · Louisburg, NCBuilt 1978 · S/N 28-7890497 N36187Swaz Aviation LLC · Mesa, AZBuilt 1978 · S/N 28-7816619 N3618MRatcliffe Andrew M · Jerome, AZBuilt 1978 · S/N 28-7890319 N361MEN361me LLC · Blanding, UTBuilt 1978 · S/N 28-7890361 N361MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881588 N361NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881827 N361ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881644 N362Andi 362 LLC · Duncan, SCBuilt 1975 · S/N 28-7690096 N36209Indian Hills Community College · Ottumwa, IABuilt 1978 · S/N 28-7816622 N3621XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881010 N36276Gronning Skyler · Westby, WIBuilt 1978 · S/N 28-7816624

Back to AD 2016-07-21