Skip to content

Registered aircraft · 5,462

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.

N18WRN18wr LLC · Mesa, AZS/N 28-8190185 N1901HLuing Daniel M · Chippewa Falls, WIBuilt 1977 · S/N 28-7716059 N1902HAbraxis Air LLC · Casa Grande, AZBuilt 1977 · S/N 28-7716060 N1903HEsp Aviation LLC · Mason City, IABuilt 1977 · S/N 28-7790351 N1904HSpyropoulos Basil P · Lake Geneva, WIBuilt 1977 · S/N 28-7790352 N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245 N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061 N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062 N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017 N192AMN34cc LLC · Liberty, NCBuilt 2021 · S/N 2881507 N192PPiper Aircraft Inc · Vero Beach, FLS/N 28020294 N1934HMaloney Loran D · Barnhart, MOBuilt 1977 · S/N 28-7716065 N1936HBarts Flying Service · Storm Lake, IABuilt 1977 · S/N 28-7716066 N1937HTerra Alfred Jr · Taunton, MABuilt 1977 · S/N 28-7790358 N1939GMorgan Larry D · Blair, NEBuilt 1989 · S/N 2890107 N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018 N193LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010067 N1941VSale Reported · Bloomburg, TXSale reported, canceledBuilt 1984 · S/N 28-8490056 N1946HMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716067 N194GSMaster Aviation LLC · Intl Falls, MNBuilt 2022 · S/N 2881515 N1959HN1959h Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28-7790361 N195MASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881029 N1961JCullen Stephen · Washington, INBuilt 1978 · S/N 28-7890476 N1970HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716071 N1973HAllen Quandt Inc · Grand Island, NES/N 28-7716073 N1978HHarow Peter M · Forked River, NJBuilt 1977 · S/N 28-7790364 N1986HTraining Planes LLC · Tampa, FLS/N 28R-7737022 N198FTOrtiz Santiago Gil · Miami, FLBuilt 1982 · S/N 28-8216198 N198SWFerguson Robert S · Riverview, FLBuilt 1977 · S/N 28-7890130 N1992HBradley Aircraft Company LLC · Columbus, INBuilt 1977 · S/N 28-7716076 N1993HSmith Brian S · Spring, TXS/N 28-7790367 N1995HFogarty Jayne I · Hartford, SDBuilt 1977 · S/N 28-7790369 N1996HLord Alan T · Reynoldsburg, OHBuilt 1977 · S/N 28R-7737023 N199AVEcho Mike LLC · Baldwin, NYBuilt 1981 · S/N 28-8116283 N199BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881956 N199GWRaleigh Flying Club LLC · Chapel Hill, NCS/N 28-7990268 N19AVGhafouri Mohsen · Murrieta, CABuilt 1981 · S/N 28-8216106 N1UKPenn Flight School LLC · Quakertown, PABuilt 1977 · S/N 28-7790564 N2003MRoyal Timothy G · Apex, NCBuilt 1977 · S/N 28-7890221 N2007MCritz Sue A · El Paso, TXBuilt 1977 · S/N 28R-7837061 N200ADNouvel Avion LLC · Miami Gardens, FLBuilt 1976 · S/N 28-7690230 N200DWLillian Aviation LLC · Cypress, TXBuilt 2003 · S/N 2844102 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N203DAerotres LLC · Lakeville, MNBuilt 2020 · S/N 2881425 N203EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020118 N203FSpace Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 288416083 N2043MPaxton Flyers · Loda, ILBuilt 1977 · S/N 28-7816241 N2044MDowling Michael L · Adrian, MIBuilt 1977 · S/N 28-7816242 N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244 N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119

Back to AD 2016-07-21