Skip to content

Registered aircraft · 85,616

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.

N1307HDileo Steven · Gallatin, TNS/N 28-7716015 N1307YOrange County Flight Center Inc · Santa Ana, CABuilt 1961 · S/N 17249007 N1307ZFerris Dale E · Willsboro, NYS/N D-6742 N13081Eagle East Aviation Inc · North Andover, MABuilt 1973 · S/N 17262481 N13083Cloud Surfer N13083 LLC · Helena, MTBuilt 1973 · S/N 17262483 N1308BHopewell Jeffrey D · Temple, TXBuilt 1955 · S/N 23-340 N1308GRed Over White Aviation · Louisville, KYBuilt 1974 · S/N 310Q1149 N1308SCecil Donald C · Willows, CABuilt 1976 · S/N 18264873 N1308YBrewer Lester A · Magna, UTFirst renewal noticeS/N 17249008 N1308ZDelaney Troy · Lake Ozark, MOBuilt 1961 · S/N D-6743 N13093Multiflight II Inc · Lakeville, MNBuilt 1973 · S/N 17262488 N13095Air Ally Asset Management LLC · Chisago City, MNBuilt 1973 · S/N 17262489 N13096Flights Cool LLC · La Conner, WABuilt 1973 · S/N 17262490 N13099Steeber Pauline M · Mcmurray, PABuilt 1973 · S/N 17262493 N1309DOld Buzzard Aviation Inc · Middleburg, FLBuilt 1951 · S/N 19885 N1309SBlackburn Mark R · Saint Paul, KSBuilt 1976 · S/N 18264874 N1309U129w Holdings LLC · Terlingua, TXBuilt 1976 · S/N 17266999 N1309WSanford Mark J · Ithaca, NYBuilt 1963 · S/N 197 N1309YC747 LLC · Wilmington, DEBuilt 1961 · S/N 17249009 N1309ZReady Aim Flyer LLC · New Castle, DEBuilt 1961 · S/N TD-463 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130BVTheophanis Charters LLC · Stuart, FLS/N 31-7952216 N130BWPobiega Michael J · Fort Mill, SCBuilt 1970 · S/N 32-40963 N130DABornheber Ralf · DraskovicS/N 17265713 N130DGDixie Aviation LLC · Pelham, ALBuilt 1972 · S/N 28R-7235127 N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124 N130JMRegistration Pending · Tampa, FLRegistration pendingBuilt 1982 · S/N 28-8390036 N130KSouthern Aircraft Consultancy Inc Trustee · NorfolkRegistration ineffective or invalidBuilt 1978 · S/N 32R-7885109 N130LAInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 21-1175 N130MMMighty Mike LLC · Maysville, KYBuilt 1964 · S/N 30-550 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477 N130RCWilliams Brian G · Las Cruces, NMBuilt 1983 · S/N P21000822 N130RRAllbritten Jeffrey P · Winder, GAS/N 2841264 N130TLynch Machining LLC · North Vernon, INBuilt 2003 · S/N 2844104 N130TCVogt Richard L · Panama City Beach, FLBuilt 1976 · S/N 18264999 N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003 N13100Ruttenberg Barbara A · Lexington, KYBuilt 1973 · S/N 17262494 N13101North Hollywood Optimist Club Youth · Van Nuys, CABuilt 1973 · S/N 17262495 N13104Erley Robert B · Kirkland, WABuilt 1973 · S/N 17262498 N13109Illinois Valley Flying Club · Peru, ILBuilt 1973 · S/N 17262503 N1310AKoep Evan T · Brookings, SDBuilt 1967 · S/N CD-1105 N1310FHumphries Aviation LLC · Maysville, KYBuilt 1966 · S/N 17254805 N1310KVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7790216 N1310UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020247 N13115Kkmjj LLC · South Lyon, MIBuilt 1973 · S/N 17262507 N13117Mccullough James R · Newville, PABuilt 1973 · S/N 17262509 N13119Boomer Aviation LLC · Catoosa, OKBuilt 1973 · S/N 17262511 N1311DAntkowiak Colton C · Chugiak, AKBuilt 1951 · S/N 19887 N1311GGranite Mountain Flight Training LLC · Prescott, AZBuilt 1974 · S/N 310Q1152 N1311SCutlass 661 LLC · Orange Park, FLBuilt 1976 · S/N 18264876

Back to AD 98-21-21 R1