Registered aircraft · 250

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:75-12-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-09-R2') 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:75-12-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-09-R2')
  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:75-12-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-09-R2')
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.

N2657BHughes Coby D · Collinsville, OKS/N 157 N2665BSteria Kermit J · Monahans, TXBuilt 1956 · S/N 374 N2700BBackcountry Commander LLC · Wray, COBuilt 1955 · S/N 200 N272CACentral Airlines Inc · Leawood, KSBuilt 1964 · S/N 1409-146 N2732BWolff Martin · Houston, TXBuilt 1955 · S/N 232 N274LECsonka Bela · Hesperia, CABuilt 1962 · S/N 500A-1232-69 N2750BRodrigues Steven W · Manteca, CABuilt 1956 · S/N 410 N2755LMerxbauer Terry E · La Pine, ORBuilt 1955 · S/N 680-255 N2782BAbbing Frits G H · Crescent City, FLBuilt 1957 · S/N 559 N2788BK&L Agri Farms Inc · Adams, NEBuilt 1957 · S/N 560 N280MBWeber Donald E · St David, AZBuilt 1975 · S/N 3255 N289GRAerocomm LLC · Kalispell, MTBuilt 1959 · S/N 795 N292SMartin James David · Graford, TXBuilt 1976 · S/N 3274 N2BZBosco74 LLC · Wilmington, DEBuilt 1975 · S/N 3227 N303HAirborne Solutions Group · Dayton, OHBuilt 1963 · S/N 1312-62 N304JTCentral Airlines Inc · Overland Park, KSBuilt 1965 · S/N 1494-175 N30UAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1955 · S/N 247 N311PWQuantic LLC · Morrisville, NCBuilt 1961 · S/N 500A-1106-54 N312ECAmy Johan J · Coral Springs, FLBuilt 1958 · S/N 676-27 N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99 N324RRCentral Airlines Inc · Overland Park, KSBuilt 1964 · S/N 1386-139 N329RSTeichman David · Dade City, FLBuilt 1963 · S/N 1303-118 N32GLG E Air Inc · Broussard, LABuilt 1978 · S/N 3312 N333BENtn3n LLC · Titusville, FLBuilt 1960 · S/N 500A-979-33 N3341Sale Reported · La Plata, NMSale reported, pending cancellationBuilt 1956 · S/N 680-456-126 N33PGFoundation Of Wayne Community College Inc · Goldsboro, NCS/N 1782-5 N346UDJack W Berry And Associates Inc · Peachtree City, GABuilt 1965 · S/N 1539-193 N353CCThree Jay Enterprises LLC · Los Altos, CABuilt 1962 · S/N 500B-1230-105 N37CKSale Reported · Saint Thomas, VISale reportedBuilt 1962 · S/N 500A-1251-76 N3836CAdvanced Airways Inc · Loxahatchee, FLS/N 791 N3846CCrowder Eston W · Dade City, FLS/N 709 N39GWKotalite Consultant LLC · West Palm Beach, FLS/N 3096 N3UVPonderosa Aviation LLC · Safford, AZBuilt 1973 · S/N 3146 N411ETCentral Airlines Inc · Overland Park, KSBuilt 1966 · S/N 1621-214 N411FSRomain Bevin G · St Thomas, VIBuilt 1962 · S/N 1162-85 N411JFCentral Airlines Inc · Overland Park, KSS/N 500B-1014-35 N411PTCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1207-99 N411VVScott William H · Mount Pleasant, SCS/N 520-39 N4131BPadgett Mfg Inc · Bradenton, FLBuilt 1952 · S/N 520-35 N4136BWright Michael E · Hurricane, UTBuilt 1953 · S/N 52040 N4142BKnutson Wayne R · Tioga, NDBuilt 1953 · S/N 520-47 N415BHCentral Airlines Inc · Overland Park, KSBuilt 1960 · S/N 500B-918-5 N4179BMitchell Matthew K · Cushing, OKBuilt 1953 · S/N 520-86 N4189BKruger Thomas H · Hoquiam, WABuilt 1953 · S/N 520-96 N41KVRockberry LLC · Wilmington, DEBuilt 1964 · S/N 1422-69 N424RKTerry Ryan · White Lake, MIBuilt 1955 · S/N 238 N4278SChagnot Catherine J · Athens, OHBuilt 1959 · S/N 680E-813-60 N42MSPlukair Texas LLC · Houston, TXBuilt 1976 · S/N 3259 N42NZCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1979 · S/N 3322 N443WACentral Airlines Inc · Overland Park, KSBuilt 1963 · S/N 1315-124

Back to AD 75-12-09 R2