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.

N243SDRegistration Pending · Brookings, SDRegistration pendingBuilt 2024 · S/N 4496576 N2440DXing Kong Aviation Service LLC · Atwater, CAS/N 4496305 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N244ABParton Aviation Co LLC · Rutherfordton, NCBuilt 1979 · S/N 31T-8004015 N244ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496043 N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025 N2454FOlson Donald C · Golovin, AKS/N 27-2666 N2458RKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2004 · S/N TH-2089 N2458WBig Bend Outdoor Center LLC · Pittsburg, TXBuilt 1979 · S/N 31T-8004017 N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187 N245ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496046 N245BMBen-Hur Air Chariots LLC · Fort Myers, FLBuilt 1971 · S/N 310Q0411 N245CBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 34-8333007 N245GTChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496489 N245JKSpruce Hill Leasing LLC · Hadley, MAS/N 414A0613 N245MWArment Christopher · Aberdeen, SDBuilt 1967 · S/N 30-1502 N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104 N245TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 4496595 N246BGuynn Dane L · Peachtree City, GAS/N 310K0030 N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841 N246BMBlue Oasis Flight Support · Tamarac, FLBuilt 1978 · S/N 34-7870083 N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769 N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253 N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817 N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678 N2474SEllison William K · Tipton, INBuilt 1967 · S/N 337-0774 N247EFNobles Vernon H Jr · Calabasas, CABuilt 1968 · S/N 310P0023 N247GNTommy Hanka Farms LLC · Mission, TXBuilt 1968 · S/N TC-1119 N247HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800720 N247TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496612 N2486SDarvek LLC · Las Vegas, NVBuilt 1967 · S/N 337-0786 N2486UGuardian Flight LLC · South Jordan, UTS/N 34-7970446 N248JBRiverode Sales Inc · Pontiac, ILBuilt 1978 · S/N TC-2124 N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004 N248LTOconnell Christopher · Tucson, AZBuilt 1975 · S/N 34-7570019 N248MHatton Wesley · Murrieta, CABuilt 1964 · S/N TC-558 N248TFVisionary Holdings LLC · Missoula, MTBuilt 2025 · S/N 4496613 N2491SGeorge Ladelle L · Ashley, NDBuilt 1967 · S/N 337-0791 N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249 N249TGHoot Aero LLC · Baton Rouge, LABuilt 2015 · S/N 20800579 N249WKz805 LLC · Wilmington, DES/N 34-7770312 N24AKLund Kristoffer B · Encinitas, CABuilt 1968 · S/N TC-1150 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659 N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049 N24DCCraig Joshua · Bonaire, GABuilt 1975 · S/N 33701640 N24GBSmith Loren · Great Falls, MTS/N 421C0287 N24GMFive X Five Flight Inc · The Woodlands, TXBuilt 1981 · S/N ME-395 N24KMNorthern Jet Inc · Iron Mountain, MIS/N 310Q0631 N24MAMarsh Glen R · Williamson, GABuilt 1972 · S/N TC-1435 N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705

Back to AD 2004-25-16 R1