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.

N4WZMulligan Peter · Richardson, TXBuilt 1970 · S/N TH117 N4YASoaring Eagle Southwest LLC · Fort Mohave, AZS/N 30-365 N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318 N5008AWings Like Eagles LLC · Wilmington, DES/N 27-3695 N5009QWeed Ryan W · San Francisco, CABuilt 1968 · S/N 310N-0109 N500BAKw Plastics · Troy, ALBuilt 1997 · S/N TH-1814 N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418 N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236 N500DTBlackhawk Holding Corp · Wilmington, DEBuilt 1977 · S/N 34-7770260 N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287 N500EGElliott Candice H Brown · Santa Rosa, CABuilt 1974 · S/N 27-7405453 N500GMSto Cazzo Aviation LLC · Danvers, MABuilt 1980 · S/N TC2350 N500HRDese Enterprises LLC · Huntsville, ALBuilt 1981 · S/N 318152133 N500KPPung Michael W DBA · Alma, MIS/N 31-8152094 N500LCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 27-7954060 N500LDJ & H Investment Corp Inc · Columbia, MOBuilt 1979 · S/N TH-1008 N500PSWing John E · Rowlett, TXBuilt 1966 · S/N TC-990 N500QVJands LLC · Broken Arrow, OKBuilt 1979 · S/N 340A0699 N500RFJones Anthony Blake · Sylacauga, ALBuilt 1968 · S/N 310P0026 N500SHMergili Joseph P · El Paso, TXBuilt 1968 · S/N 310N-0108 N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027 N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585 N500TLSententia LLC · Highland Park, ILBuilt 1999 · S/N TH-1890 N500YEHill Clifford D · Warsaw, INBuilt 1971 · S/N TC-1399 N5011QBoh-Air Corporation · Jenks, OKBuilt 1968 · S/N 310N-0111 N5012AEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeBuilt 2001 · S/N 4496044 N5013QTesini Allan J · Zephyrhills, FLBuilt 1971 · S/N 340-0008 N5017MNo Limits Aviation Inc · Lincoln, MTS/N ME-54 N5018YHighland Rim Aviation LLC · Springfield, TNBuilt 1963 · S/N 27-2020 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N501CLSalt Aerial Aviation LLC · Hamel, MNS/N 414A0339 N501DCExecutive Aviation LLC · Peoria, AZBuilt 1981 · S/N 340A1267 N501DMNeely Aviation Services Corp · Port Orange, FLS/N 34-7870375 N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21 N501MLVotava Paul A · Mcintosh, MNBuilt 1970 · S/N TH-72 N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194 N501WTPeterson Floyd M · Lago Vista, TXBuilt 1979 · S/N TC-2194 N5020QHudson Thomas C Jr · Bessemer, ALBuilt 1968 · S/N 310N-0120 N5023YAas LLC · Ovid, MIBuilt 1962 · S/N 27-2027 N5029QStormont Dylan · Xenia, OHBuilt 1968 · S/N 310N-0129 N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547 N502CSIsr Platforms LLC · Mclean, VABuilt 1966 · S/N 337-0280 N502DWSolamich Aviation LLC · Huntley, ILBuilt 1971 · S/N 39-124 N502JJMrch Airways Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1970 · S/N 414-0061 N502SAZambrano Homero Ramones · Bulverde, TXBuilt 1978 · S/N 421C0520 N5033QChanges In Attitude LLC · Monument, COBuilt 1968 · S/N 310N-0133 N5037QSayler Ben · Thief River Falls, MNBuilt 1971 · S/N 340-0012 N5037TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250205 N5038YAileron Buzz LLC · Daytona Beach, FLBuilt 1962 · S/N 27-2044 N503BAP&B Aviation Corp · Wilmington, DES/N TH-862

Back to AD 2004-25-16 R1