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.

N30100Jetstream Cowboys LLC · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870463 N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069 N3010LJones Johnny R · Thermopolis, WYBuilt 1965 · S/N 310J0010 N3011TBranson West Development Inc · Paso Robles, CABuilt 1964 · S/N 320C0011 N3012TCain James W · Big Rapids, MIBuilt 1964 · S/N 320C0012 N3015WDl321 LLC · Lavon, TXBuilt 1973 · S/N TC-1594 N3018SPerez Daniel · Pembroke Pines, FLBuilt 1965 · S/N TC-960 N3018WAerosport Aviation LLC · Laredo, TXBuilt 1973 · S/N TC-1595 N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928 N301ABCamber Aviator LLC · Miami, FLBuilt 1979 · S/N 34-7970186 N301CPWhy Not Fly Aviation LLC · Gainesville, VAS/N 414A0105 N301CTVatm Sky Investments LLC · Thomson, GABuilt 1980 · S/N TH-1166 N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916 N301PRussell Bill W · Victoria, TXBuilt 1978 · S/N TH-890 N301SEAmerican Air Academy Inc · Merritt Island, FLBuilt 2004 · S/N 3449304 N301SWFly Rite Aviation LLC · Fort Myers, FLS/N 27-195 N3020KGhostwriter Airshows LLC · Hustonville, KYBuilt 1978 · S/N 34-7970099 N3020MWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995220 N3021TGolden Arrow Transportation · Plainfield, NJBuilt 1964 · S/N 320C0021 N3023LBirge Chad W · Alcoa, TNBuilt 1965 · S/N 310J0023 N3024PPrentice Robert D · Ripon, WIBuilt 1957 · S/N 23-935 N3026TBox William C · Goldsby, OKS/N 320C0026 N3027TPlane Services LLC · Twin Falls, IDBuilt 1964 · S/N 320C0027 N3028NPryor Paul Robert · Carrollton, VABuilt 1979 · S/N 34-7970116 N3029TConsolidated Resource Imaging LLC · Grand Rapids, MIBuilt 1964 · S/N 320C-0029 N302EFRedbird Ventures LLC · Kalispell, MTS/N 34-7350328 N302PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 4496121 N302SKHaynes Daniel R · New Braunfels, TXBuilt 1965 · S/N 310J-0036 N302TAMidwest Flying Service LLC · Wilmington, DEBuilt 1980 · S/N 31T-8020046 N302VMWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995322 N3031DApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995142 N3031LCavender Kelly P · Prosper, TXBuilt 1965 · S/N 310J0031 N3032ALynn University Inc · Boca Raton, FLS/N 3449294 N3032PMenard Charles H · Grand Blanc, MIBuilt 1957 · S/N 23-943 N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869 N3033NVyse Aviation LLC · Deer Park, ILBuilt 1979 · S/N 44-7995227 N3034LTown Thomas L · Chino Valley, AZBuilt 1965 · S/N 310J0034 N3034TVelez Investments LLC · Orlando, FLS/N 320C0034 N3035NPs N3035n LLC · Green Bay, WIBuilt 1979 · S/N 44-7995228 N3036WSpowart James F DBA · Huntington Beach, CABuilt 1973 · S/N P-236 N3039TDdc Investments LLC · Hot Springs, ARBuilt 1964 · S/N 320C0039 N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028 N303BBPerry Clifton B · Lacon, ILBuilt 1964 · S/N TC-787 N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069 N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022 N303CKRegistered aircraftBuilt 2002 · S/N 3449257 N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296 N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043 N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068 N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038

Back to AD 2004-25-16 R1