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.

N16496Gesler Mark A DBA · Lima, OHBuilt 1973 · S/N 28-7305270 N16497Brennan Daniel C · Powell, WYBuilt 1973 · S/N 28-7310101 N16498Owens Hay LLC · Crane, ORBuilt 1973 · S/N 32-7340091 N1649FWalton Amber · Upper Sandusky, OHS/N 17255044 N1649JRegistration Pending · Bozeman, MTRegistration pendingBuilt 1967 · S/N 28-24042 N1649MMitten Aero LLC · Lexington, MIS/N 18264402 N164AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010060 N164BPlummer Keith G · Tishomingo, OKBuilt 1955 · S/N D-4437 N164DPAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 28-8016190 N164ERSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2841180 N164GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881457 N164JAgster Robert J · Fstrvl Trvose, PABuilt 1980 · S/N 32R-8029071 N164JDDominik James W · Golf, ILBuilt 1966 · S/N 18051816 N164JMWind Sand & Stars Aviation LLC · San Diego, CABuilt 1978 · S/N R18200158 N164LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010063 N164LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-714 N164RStigliano James II · Townsend, GAS/N D-2519 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 N164ULariviere Jeffrey A · Douglassville, PABuilt 1967 · S/N 32-996 N164VPConservation Aviation LLC · Washington, DCS/N U20601942 N16509Greensburg Jeannette Airport Administration · Jeannette, PABuilt 1973 · S/N 28-7305271 N1650CBrokaw Samuel J · South Bend, INBuilt 1953 · S/N 30350 N1650F4 Aces Air LLC · Brandon, MSS/N 17255045 N1650JQureini Khalil H Vii · Kansas City, MOBuilt 1967 · S/N 28-24043 N1650WGriffin Michael D · Madison, ALBuilt 1972 · S/N E-352 N1650YAirria Holdings LLC · BerlinBuilt 1962 · S/N 17249350 N1650ZRobinson Christopher C · Olivet, MIBuilt 1962 · S/N 185-0450 N16513Ashworth Diane A Executor · Chase City, VABuilt 1973 · S/N 28-7305273 N16518Dokter Garret H Jr Trustee · Big Bear Lake, CABuilt 1973 · S/N 28-7310102 N1651DWeber Donald B · Chugiak, AKBuilt 1952 · S/N 20293 N1651ENoffsinger Robert L · Winston Salem, NCS/N 17271081 N1651FMurphey Julian R · Knoxville, TNS/N 17255046 N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686 N16526Wesley Joseph L · Pismo Beach, CABuilt 1973 · S/N 28-7325291 N16527Skolnick Sanford M · Novato, CABuilt 1973 · S/N 28-7305274 N1652DFischer Andrew G · Hopkins, MNBuilt 1952 · S/N 20294 N1652HDemelva Aviation LLC · Alexandria, VAS/N 32R-7780168 N1652NAllison Christopher · Cartersville, GABuilt 1999 · S/N 3257119 N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687 N1652YWallitner Matthew M · Oroville, WABuilt 1962 · S/N 17249352 N16530Beldon Concrete LLC · Liberty, KYBuilt 1973 · S/N 28R-7335158 N16531Bethge Wade K · Paxinos, PABuilt 1973 · S/N 28R-7335159 N16534Wahler Edward William III · Asheville, NCBuilt 1973 · S/N 28-7325292 N16535Wdc Enterprises LLC · Beaumont, TXBuilt 1973 · S/N 28-7325293 N16537Lesmeister Dillon J · Chadron, NEBuilt 1973 · S/N 28-7305277 N1653CLoveness Ghyrn E · Cave Creek, AZBuilt 1953 · S/N 30353 N1653FN1653f LLC · Miami, FLBuilt 1966 · S/N 17255048 N1653JSale Reported · Bloomburg, TXSale reportedBuilt 1967 · S/N 28-24047 N1653YBarua Dennis · Midland, TXS/N 17249353 N16542Marianas Air Transfer Inc · Saipan, MPS/N 32-7340093

Back to AD 98-21-21 R1