Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N37478Ghareeb Enterprises Inc · Charleston, WVS/N 421C0415 N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818 N374PDavhen Aero LLC · Anderson, SCBuilt 1974 · S/N 27-7405410 N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105 N3752CMiller Robert G · Clear Lake, IAS/N 414-0819 N37543Construction Solutions & Consulting LLC · Sedalia, MOS/N 414A0002 N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839 N375AZSale Reported · Guatemala CitySale reportedS/N 27-7854038 N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226 N3760BSavage David C · Austin, TXBuilt 1979 · S/N TC-2109 N3766RHarrigan Patrick · Hickory, NCBuilt 1968 · S/N 337-1034 N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584 N376DGClark Anthony · Augusta, KSBuilt 1976 · S/N 31P-7630015 N376NCLima Delta Company Trustee · New Castle, DEBuilt 1977 · S/N 31-7852048 N37777Quiet Aviation LLC · Longwood, FLS/N 337-0898 N377DWSoutheastern Aircraft Inc · Birmingham, ALBuilt 1965 · S/N 27-3063 N377GGemini Southern LLC · Orlando, FLBuilt 1969 · S/N TC-1276 N377HHJennings Christopher Wyckoff Trustee · Brentwood, TNBuilt 1970 · S/N 39-13 N377JMSanchez Joshua A · Bosque, NMBuilt 1976 · S/N 421C0221 N377JS270 Aviation LLC · Elizabethtown, KYBuilt 1979 · S/N 340A0672 N377WTAaronian Randall · Kingsburg, CABuilt 1980 · S/N 34-8070283 N378KAga Aviation LLC · Lewes, DES/N 421C0499 N378MMBento De Deus Amarildo · Margate, FLBuilt 1978 · S/N 31-7812118 N379BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20800414 N379JRDanny Skaggs Co Inc · San Antonio, TXBuilt 1984 · S/N TJ-447 N379LV379lv LLC · Broomfield, COBuilt 1982 · S/N TJ423 N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616 N37BJDodson Jeffrey C · Monroe, GABuilt 1973 · S/N 33701503 N37FSLuxury Transportation LLC · Talladega, ALS/N 414A0830 N37GMCraft Engineering Associates Inc · Hampton, VABuilt 1979 · S/N 340A0684 N37JKSsr LLC · Incline Village, NVS/N 421B0934 N37MBresciani Martin · Guaynabo, PRS/N 421B0805 N37PAThree Rivers Aero LLC · Three Rivers, MIS/N TC-1267 N37PFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 34-8070359 N37PJDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7904003 N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823 N37SACampbell John R Trustee · Saint Leo, FLBuilt 1972 · S/N 34-7250046 N37UJet Set Aircraft Inc · Van Nuys, CABuilt 1977 · S/N 414A0010 N37USSouthern Aircraft Consultancy Inc Trustee · Bergh Apton NflkRegistration ineffective or invalidBuilt 1980 · S/N 34-8070111 N38020Pardue Hines Aviation LLC · Lincolnton, NCBuilt 1980 · S/N TH-1208 N3803ESorbi Aviation Inc · El Cajon, CABuilt 1981 · S/N ME-381 N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381 N3804MGlenmont Air LLC · Strasburg, VABuilt 1981 · S/N TJ-328 N3806XTessec LLC · Cincinnati, OHBuilt 1980 · S/N TH-1215 N3807TAmbrose Construction Ltd · Corpus Christi, TXBuilt 1980 · S/N TJ-332 N38088Toledo Jorge A · Coral Gables, FLS/N TC-2366 N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218 N3809KGeneral Aviation Services LLC · Franklin, TNBuilt 1981 · S/N TH-1219 N3809XVoracek Michael G · Richardson, TXBuilt 1966 · S/N 310K-0209 N380AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496618

Back to AD 2004-25-16 R1