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.

N607TCState Of Alaska · Anchorage, AKBuilt 2018 · S/N 20800607 N6082SWro LLC · Conway, ARS/N TC-1914 N6084CBig Bend Community College · Moses Lake, WABuilt 2008 · S/N 4496267 N6084SGraves Dorel Jr · Danville, INBuilt 1975 · S/N TC-1913 N6085YPharmair LLC · Jackson, MSBuilt 1966 · S/N 27-3287 N6089YAerosavant LLC · Towanda, PABuilt 1966 · S/N 27-3295 N6092YClean Waste Solutions LLC · Indianapolis, INBuilt 1966 · S/N 27-3298 N6096SMortensen Daniel R Trustee · Newhall, CABuilt 1975 · S/N TH-699 N609DSTj Air Holdings Inc · Wilmington, DEBuilt 1981 · S/N T30300025 N609MAAcenes LLC · White Plains, NYBuilt 1999 · S/N 3449109 N60AY2701 Ne 27 Court LLC · Hollywood, FLBuilt 1981 · S/N 31-8152051 N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206 N60CLJubjub LLC · Shawnee, KSBuilt 1972 · S/N P-201 N60DMDatom Inc · Culver City, CABuilt 1979 · S/N 340A0711 N60EDawson Aircraft Inc · Clinton, ARBuilt 1979 · S/N 340A0663 N60ETChankhunthod Anawat · Saratoga, CAS/N TK-57 N60FYNew Castle Aviation Inc · Durham, NHBuilt 1969 · S/N 310P0109 N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828 N60JWTumbleweed Leasing LLC · Tacoma, WABuilt 1980 · S/N 31T-8004031 N60LFNorthwoods Air LLC · Orono, MEBuilt 1978 · S/N 27-7854111 N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544 N60PFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N P-87 N60PPJaams LLC · Shafter, CABuilt 1976 · S/N 340A0073 N60RKMajeste Air LLC · Reno, NVBuilt 1969 · S/N P-79 N60SHBas Part Sales LLC · Greeley, COBuilt 1980 · S/N TJ-267 N60TAAero Elite LLC · Springfield, MOS/N 31-7552094 N60WATextron Aviation Inc · Wichita, KSS/N 20800729 N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083 N60WUWsu Campus Of Applied Sciences And Technology · Wichita, KSBuilt 2025 · S/N 4496615 N60YAnthem Commercial Air Services Inc · Saint Augustine, FLBuilt 1976 · S/N 33701735 N6107AR & R Aviation Support LLC · Atlanta, GABuilt 1978 · S/N 31T-7820087 N610AKBaja Electric Service Inc · Punta Gorda, FLBuilt 1974 · S/N 310Q-1072 N610MMMaxq Composites LLC · Oxford, MEBuilt 1968 · S/N 337-0961 N610RCHallada William A · Barnesville, GAS/N 310-0115 N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890 N611BT-2 Enterprises LLC · Walla Walla, WABuilt 1981 · S/N 31T-8166015 N611DPInversiones Flg Inc · Dorado, PRBuilt 1977 · S/N 31-7812040 N611LLevesque Michael C · Hampden, MEBuilt 1999 · S/N 208-00299 N611SGRph Engineering LLC · Lehi, UTBuilt 1979 · S/N 27-8054020 N611WWCone S E Jr · Hobbs, NMBuilt 1978 · S/N 277854093 N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332 N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336 N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416 N612EHIsland Flyers Inc · Addison, TXBuilt 1976 · S/N 277654161 N612JPSkyline Air LLC · Ashburn, VABuilt 1968 · S/N 310N-0116 N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927 N612KPSmith Aviation Inc · Stamps, ARBuilt 1998 · S/N TH-1857 N612MAAndraos Aviation Solutions LLC · Northville, MIBuilt 1979 · S/N TH-975 N612MRFladr LLC · Westfield, NJBuilt 1979 · S/N 27-8054008 N612TNAustin Bill DBA · Sparta, TNBuilt 1981 · S/N TH-1272

Back to AD 2004-25-16 R1