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.

N333SNHub City Aviation Academy LLC · Lubbock, TXBuilt 1966 · S/N 30-982 N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114 N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779 N333UDSpecialty Aero LLC · Seattle, WABuilt 1981 · S/N 340A1256 N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099 N333WDWoelbing Aviation LLC · Franksville, WIBuilt 1966 · S/N 310L-0002 N333WYJrm Wings LLC · Farmington, UTS/N 30-1800 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739 N33401Innes Associates Insurance Services Inc · Safford, AZBuilt 1975 · S/N 34-7570115 N3340XVito Bavaro Construction Inc · Escalon, CAS/N 310L-0190 N3341PDahl Troy M · Cedar Rapids, IABuilt 1958 · S/N 23-1294 N3341XJackson Rex A · Granbury, TXBuilt 1967 · S/N 310L-0191 N3345XTurel Gary J · Tigard, ORS/N 310L-0195 N3346PDramstad Flying Service LLC · Helena, MTS/N 23-1299 N33475Excelsior Solutions Inc · Pinehurst, NCBuilt 1975 · S/N 34-7570123 N334NCarter-Muthana Aero LLC · Bakersfield, CABuilt 1978 · S/N 421C0458 N334RPRegistration Pending · Seneca, SCRegistration pendingBuilt 1980 · S/N 31-8052071 N33511Annis Aviation LLC · Gray, GABuilt 1964 · S/N TC-800 N3353PHeffron Jacob L · Little Falls, MNBuilt 1958 · S/N 23-1308 N3353QTop Tier Truck And Trailer LLC · Amarillo, TXS/N 34-7770227 N3354QOn The Beam Aviation Inc · Hampton, GABuilt 1967 · S/N 310L-0204 N3355QSunshine Aircraft Repair Inc · Lindenhurst, ILS/N 310L-0205 N335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1389 N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418 N335DLarson Ken · Lake Havasu City, AZS/N P-129 N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320 N33646646 Lease Holding LLC · Noblesville, INS/N 34-7570140 N3364LLopez Edwin · Germantown, TNS/N 310Q0784 N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919 N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324 N33689Michair LLC · Omaha, NEBuilt 1975 · S/N 34-7570149 N336PN336p LLC · Williamstown, NJBuilt 1974 · S/N 31T-7400003 N336PAWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 4496140 N33724Mil2atp Inc · Pikeville, NCS/N 34-7570153 N33739Sale Reported · Crystal, MNSale reportedBuilt 1975 · S/N 34-7570154 N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337 N3377QMendez Jr Leo · Corpus Christi, TXS/N 421B0261 N337AFKinetic Concepts LLC · Pensacola, FLBuilt 1967 · S/N 67-21344 N337BBLewis University · Romeoville, ILBuilt 1969 · S/N 33701194 N337BNDestiny Center Inc · Murfreesboro, TNBuilt 1972 · S/N 33701449 N337CBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0905 N337CDKeller Stephen P · Wichita, KSBuilt 1973 · S/N 33701495 N337CEBeam David M · Sabina, OHBuilt 1976 · S/N 33701762 N337DTomalar Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 337-0306 N337DEAirbermz LLC · Bloomfield Hills, MIBuilt 1980 · S/N 33701943 N337DWR And R Aircraft Inc · Delray Beach, FLBuilt 1975 · S/N 33701652 N337EEAmpaire Inc · Long Beach, CABuilt 1974 · S/N 33701600 N337EPAtp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995064 N337EWWilson Cecil · Lithonia, GABuilt 1969 · S/N 337-1193

Back to AD 2004-25-16 R1