Skip to content

Registered aircraft · 85,620

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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  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:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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.

N1516VAircraft Management Services Inc · Milton, FLBuilt 1974 · S/N 17263638 N1516ZTulin Gary N · Sedona, AZS/N D-6836 N15171Eckler David L · New Hudson, MIBuilt 1972 · S/N 28-7310018 N15172Transit William B · Macomb Township, MIBuilt 1972 · S/N 32-7340018 N15176St Germain Joseph Ronald · Glenview, ILBuilt 1972 · S/N 28-7305032 N15177Air Craft Enviromental Sys Inc · Hilton, NYBuilt 1972 · S/N 28-7310019 N15179Henson Ricky T · Covington, TNBuilt 1972 · S/N 28-7225601 N1517EHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 1978 · S/N 17271031 N1517FSalter 11x LLC · Duluth, MNS/N 185-0854 N1517JPardiac Kenneth R · Howell, MIBuilt 1967 · S/N 28-23912 N1517XDippolito Thaddeus M · Sherwood, ARBuilt 1975 · S/N 28R-7535306 N1517ZFreedom Aviation LLC · Beaufort, SCBuilt 1961 · S/N CD-412 N15186N15186 LLC · Dyer, INBuilt 1988 · S/N E-2456 N15190Coastal Air · Groton, CTBuilt 1972 · S/N 28-7305034 N15191Lumpp John R · Old Brookville, NYBuilt 1972 · S/N 28R-7335033 N15198Kehl Bryan R · Moorpark, CABuilt 1972 · S/N 32-7340020 N1519CMinor Edward H · Gordon, NES/N 30219 N1519SSimmons Gene R · Vicksburg, MIFirst renewal noticeBuilt 1962 · S/N CD-498 N1519THigh Flyers Aviation Services LLC · Gaithersburg, MDBuilt 1972 · S/N 34-7250337 N1519VBent Prop LLC · Inver Grove, MNBuilt 1974 · S/N 17263641 N1519XAycd LLC · Allentown, PABuilt 1975 · S/N 28-7505238 N1519YHarrison Michael R · Woodbine, MDBuilt 1962 · S/N 17249219 N151AV51st Aero Squadron LLC · Hoover, ALBuilt 1985 · S/N 28-8590042 N151CHGharazeddine Raja · Kaplan, LABuilt 2001 · S/N 2843495 N151DB1 Zero Sierra Whisky LLC · Helena, MTBuilt 1965 · S/N 832 N151DJValley City Flying Club Llp · Valley City, NDBuilt 1975 · S/N 28-7515308 N151DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020040 N151DSCastro Salvador A · Houston, TXBuilt 1975 · S/N 28-7515287 N151FClark Robert G · Healdsburg, CABuilt 1964 · S/N TC-613 N151GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881456 N151JFAero Quest LLC · Highland, UTBuilt 1977 · S/N 28R-7703405 N151LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842194 N151MMBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7715129 N151MTIsland Mountain Aviation LLC · Vesta, MNBuilt 1973 · S/N 21059861 N151PBParker Scott L · Midland, TXS/N 185-02146 N151SFRomeo-3 Aviation LLC · Marietta, GABuilt 1974 · S/N 28-7415411 N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036 N151VTMitchell Matthew J · Penn Yan, NYBuilt 1951 · S/N D-2714 N15200Cash Warren A · Loveland, COBuilt 1972 · S/N 28-7310020 N15201Quaintance Kemper A · Culpeper, VABuilt 1972 · S/N 28-7310021 N15203Hummel David R · Cedar Falls, IABuilt 1972 · S/N 28-7325012 N15204Arthur Jeffery L · Lima, OHBuilt 1972 · S/N 28-7305035 N15207Tiburon Aviation LLC · Tampa, FLS/N 28R-7335037 N15208Colorado Northwestern Community College · Rangely, COBuilt 1972 · S/N 28-7310022 N1520GFischer Kurt C · Lyme, CTBuilt 1988 · S/N CE-1283 N1520TAaa Aero LLC · Glenwood, MNBuilt 1972 · S/N 28-7205312 N1520VBerka George · Wilmington, DES/N D-8159 N1520WMontana Fiberglass Inc · Lewistown, MTBuilt 1972 · S/N CD-1283 N1520YScott Thomas A Jr · Lawrenceburg, TNBuilt 1962 · S/N 17249220 N15215Curtis David W · Watertown, NYBuilt 1972 · S/N 34-7350036

Back to AD 98-21-21 R1