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.

N917MPPool Shark Equipment LLC · Memphis, TNBuilt 1981 · S/N TH-1243 N917TPAerial LLC · Kalispell, MTBuilt 1982 · S/N 31T8104068 N917TRTry Trying Management And Promotions LLC · Indianapolis, INS/N TH-133 N9181QWhitfield Timothy D · Fairfield, NCBuilt 1970 · S/N TC-1381 N9184XContinental Title Trust LLC Trustee · Wichita, KSBuilt 1966 · S/N 30-1041 N918BVDietz John W Jr · Westfield, INBuilt 1982 · S/N 421C1247 N918FMAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 31T-7904025 N918YInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 30736 N9195QMeadowlake Airpark LLC · Lenoir City, TNBuilt 1971 · S/N TH-152 N919BBAf Land Ventures LLC · Palm City, FLS/N 31-7852025 N919CBCatclaw Aviation LLC · San Antonio, TXBuilt 1981 · S/N 414A0672 N919FAFortnum Air LLC · Dana Point, CAS/N 414A0628 N919PJDel Rosso Peter · Los Angeles, CABuilt 1981 · S/N TK-140 N919WAMatteo Properties Inc · Wickliffe, OHBuilt 1980 · S/N 34-8070147 N91AAShine Donald J · Waterford, WIBuilt 1971 · S/N 33701382 N91BPF3 Aviation LLC · Summerville, SCBuilt 1977 · S/N 31-7812034 N91EDBarchik Edward C · Huntington Mills, PABuilt 1961 · S/N 310-0047 N91EHChristensen Del S Trustee · Friendswood, TXBuilt 1974 · S/N 310Q1132 N91JRSpring Mountain Properties LLC · Fort Smith, ARBuilt 1973 · S/N TH-313 N91KTBrotherson Travis C · Holstein, IABuilt 1978 · S/N 34-7870387 N91PWAerial Imaging Inc · South Bend, INBuilt 1976 · S/N 31-7652102 N91TWPistol Aviation LLC · Stillwater, OKBuilt 1978 · S/N 414A0117 N91WMN2sb LLC · Southlake, TXBuilt 1983 · S/N TH-1396 N91XCFitzgerald David R · Canton, OHBuilt 1971 · S/N 39-90 N9202YRomeo Aviation Ltd · Canton, OHBuilt 1983 · S/N 31P-8414004 N920CBOgden Newspapers Inc · Wheeling, WVBuilt 1981 · S/N TJ-380 N920ERSunrise Aviation · Ormond Beach, FLBuilt 1993 · S/N 4495013 N920GCSabre Drilling Consulting LLC · Summerfield, NCBuilt 1992 · S/N TH-1660 N9210YOswald Sean B Trustee · Reno, NVBuilt 1983 · S/N 31P-8414007 N9212YS & B Foundation Air LLC · Auburn, ALBuilt 1983 · S/N 31P-8414008 N9215YAstro Star Aviation Inc · Niles, MIBuilt 1968 · S/N 31-279 N9218YHubble Boeing Development Corp · Gallipolis, OHBuilt 1968 · S/N 31-282 N9219XRud Jay C · Newark, ILBuilt 1994 · S/N 34-48038 N921AJAerohippo Corp · Franklin Lakes, NJBuilt 1974 · S/N 421B0613 N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558 N921KARay Aviation LLC · Carmel, INBuilt 1984 · S/N 340A1803 N9223RRegistered aircraftBuilt 1994 · S/N 3448040 N9224YFavret Bernard A · Ocean Springs, MSBuilt 1983 · S/N 31P-8414012 N9225YDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 31P-8414015 N9226FLewis University · Romeoville, ILBuilt 1990 · S/N 4495011 N922ASSchool Of Missionary Aviation Technology · Ionia, MIS/N 414-0033 N922BVander Linden Tom · Fairfield, IABuilt 1966 · S/N TC-994 N922GBEnnis Shannon E · Chesapeake, VABuilt 1964 · S/N 310I0153 N922HBPovero Marcus E · Fort Worth, TXBuilt 1977 · S/N TH-825 N922RBCunningham John P · Anthony, NMBuilt 1974 · S/N TC-1694 N922VCorbin Tommy · Channelview, TXS/N TC-1742 N9231YBbees LLC · Moss Point, MSBuilt 1983 · S/N 31P-8414017 N9235YKamasano LLC · Highland, CABuilt 1983 · S/N 31P-8414020 N9237YIal Corp · Lewes, DES/N 31P-8414022 N9239QRegistration Pending · Bessemer, ALRegistration pendingBuilt 1971 · S/N TH-139

Back to AD 2004-25-16 R1