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.

N28088Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881393 N2809Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010051 N28090Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881394 N28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2020 · S/N 2881395 N28096Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881405 N28098Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881406 N280BGD&J Aviation LLC · Gotha, FLBuilt 2002 · S/N 2842167 N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154 N280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733 N280NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844014 N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230 N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101 N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052 N28154Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843728 N2815FKlopping William E · Apple Valley, CAS/N 28-7916438 N2816GGiles Aviation LLC · Spring, TXBuilt 1979 · S/N 28-7990451 N2816NAlford Hobart R · Palm City, FLBuilt 1979 · S/N 28-7990452 N2816PNetz Aviation LLC · Grand Ledge, MIS/N 28-7990453 N2817D2b Group LLC · West Dundee, ILBuilt 1979 · S/N 28-7990455 N2817LHopkins Dennis L · Bark River, MIBuilt 1979 · S/N 28-7990456 N2818AHengemuhle Ronald J · Long Prairie, MNBuilt 1979 · S/N 28-7990459 N2818MMarotta Robert J · San Diego, CABuilt 1979 · S/N 28-7990462 N2818SAviator Antics LLC · Grand Forks, NDBuilt 1979 · S/N 28-7990466 N2818XBarr Suzanne Renee · Cape Coral, FLBuilt 1979 · S/N 28-7990467 N2819DAicg Group I LLC · Sheridan, WYBuilt 1979 · S/N 28-7990469 N281BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842280 N281BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881665 N281CFCharlie Foxtrot Corp · Colleyville, TXBuilt 1977 · S/N 28-7816111 N281HPMuggles Ltd LLC · East Fallowfield, PABuilt 2000 · S/N 2843323 N281KCFly Kilo Charlie LLC · New Century, KSS/N 28-8216130 N281NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844015 N281TWSkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881091 N2822STwo Two Sierra LLC · Austin, TXBuilt 1979 · S/N 28-7990470 N2822YThayer Robert N · Portola, CABuilt 1979 · S/N 28-7990471 N2823DOloteo Dennis R Jr · San Antonio, TXBuilt 1979 · S/N 28-7990472 N28251Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843729 N2825MStanton Jeffrey C · Bracey, VABuilt 1977 · S/N 28-7816313 N282BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842418 N282BLBlue Line Aviation LLC · Winter Haven, FLBuilt 2023 · S/N 2881674 N282DXPiper Aircraft Inc · Vero Beach, FLS/N 28010106 N282HGCompass Rose 2 LLC · Austin, TXBuilt 1995 · S/N 2842007 N282HPSale Reported · OxonSale reportedBuilt 2000 · S/N 2843354 N282MBMitchell Larry N · Fredericksburg, TXBuilt 2000 · S/N 2843366 N282MKAlpe Holding LLC · Van Nuys, CABuilt 2003 · S/N 2842188 N282NDMoore Aviation Inc · Beaver Falls, PABuilt 2000 · S/N 2844024 N2830JPagano Nathan J · New Haven, CTBuilt 1979 · S/N 28-7916456 N2832MCronin Terrance F · Federal Way, WABuilt 1977 · S/N 28-7816316 N2833DScott Glen H · Spring, TXBuilt 1979 · S/N 28-7916451 N2833FWeaver Arnold G · Sandusky, MIBuilt 1979 · S/N 28-7916452 N2833NLansing Community College · Mason, MIBuilt 1979 · S/N 28-7916453

Back to AD 2016-07-21