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.

N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457 N61BBAeronautical Technical Service Inc · Collierville, TNS/N 30-875 N61DDKissner Mark E · Frederick, MDS/N 340A1037 N61DPDjp Enterprises Inc · Chandler, TXBuilt 1981 · S/N 348133043 N61ESTtl Aero LLC · Oklahoma City, OKBuilt 1964 · S/N TC-682 N61FHCloud Dancer Aviation Inc · Deland, FLBuilt 1972 · S/N 34-7250255 N61HBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3449217 N61JV61jv LLC · Chuckey, TNS/N 421C0097 N61KBPegasus III LLC · Wilmington, DEBuilt 1981 · S/N 31-8152156 N61LMBowling Realty Inc · Jackson, MSBuilt 1981 · S/N 34-8133192 N61MGDominion Air Charter Inc · Louisa, VABuilt 1974 · S/N 277405285 N61NCNorthwest Florida Flight Services LLC · Jacksonville, FLS/N 27-4184 N61PZRoughneck Supply LLC · Muskogee, OKBuilt 1982 · S/N TH-1352 N61RWAerial Services Inc · Cedar Falls, IABuilt 1966 · S/N 320E0001 N61UComanche Skye LLC · Savannah, GABuilt 1966 · S/N 30-1004 N61WAWacouta Aircraft Leasing LLC · Las Vegas, NVBuilt 2025 · S/N 20800718 N61WWKingsboro David · Menifee, CABuilt 1973 · S/N 340-0203 N6205YMarschke Corey A · Stevens Point, WIBuilt 1966 · S/N 27-3432 N6206HBaas Holdings LLC · Lewes, DES/N 34-7870057 N6207NAdvanced Sport Psychology LLC · Orlando, FLBuilt 1980 · S/N 34-8070306 N620CAFar West Leaseco LLC · Kalispell, MTS/N 414-0916 N620DBAlco Plane Co LLC · Memphis, TNBuilt 1979 · S/N 31T-7920055 N620GDrygala Marcin · Williamsburg, VABuilt 1966 · S/N TC-978 N620JPPreiss Aviation Inc · Poplar Grove, ILBuilt 1972 · S/N 310Q0639 N620RMCbs Inc DBA · Bellefontaine, OHFirst renewal noticeS/N 31-7552040 N620ZSix Twenty Zulu Aviation LLC · Wilmington, DEBuilt 1973 · S/N TH-385 N6219CAbbott Todd Christopher · Houston, TXBuilt 1977 · S/N 340A0424 N6219YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3446 N621AKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 31T1104014 N621DEDesert Excavating Inc · Yuma, AZBuilt 2002 · S/N TH-2032 N621EDPhantom Aviation LLC · Ormond Beach, FLBuilt 1977 · S/N 34-7770165 N621GTFox Edward Philip Jr · New Market, ALS/N M337-0292 N621KTDdm Aviation LLC · Coral Gables, FLBuilt 2021 · S/N 20800674 N621LGAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2002 · S/N 3449296 N621NMAirmorgan Limited LLC · Reno, NVBuilt 1974 · S/N TH-422 N6220FHeberle David B · Castroville, TXBuilt 1965 · S/N 337-0220 N6221CSahuaro Enterprises Inc · Moreno Valley, CAS/N 340A0426 N62254Richard Nestor · Boise, IDS/N TJ-431 N6225XN6225x LLC · Henderson, TNBuilt 1979 · S/N 340A0688 N6228FLynch Kent · Edwards, ILBuilt 1965 · S/N 337-0228 N6228XMad Doog Aviation LLC · Kalispell, MTBuilt 1977 · S/N 340A0431 N622AJYonder Corp · Wilmington, DEBuilt 1976 · S/N 31-7612083 N622BRidley Aircraft & Aviation Services LLC · Gilbert, AZBuilt 1966 · S/N 1341 N622JBSun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995080 N622KCarr Randal J · Chandler, OKBuilt 1975 · S/N 27-7554088 N622LPClear Skies Avionics Inc · Clearwater, FLS/N 310L-0131 N622TBPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854091 N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858 N6230HBrumley Nelson B · Huntsville, TXS/N 34-7870059 N6230YRegistration Pending · Chapmansboro, TNRegistration pendingBuilt 1966 · S/N 27-3459

Back to AD 2004-25-16 R1