Registered aircraft · 274

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

N23BQCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500A-1065-46 N2415SDodson International Parts Inc · Rantoul, KSS/N 1860-39 N244ACScruggs Ken · Galloway, OHBuilt 1968 · S/N 1815-21 N261ERCentral Airlines Inc · Overland Park, KSBuilt 1963 · S/N 1362-133 N264RWDeneve Antoinette · De Kalb, TXBuilt 1952 · S/N 520-46 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 N2732BWolff Martin · Houston, TXBuilt 1955 · S/N 232 N2749GLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1971 · S/N 6047 N274LECsonka Bela · Hesperia, CABuilt 1962 · S/N 500A-1232-69 N2750BRodrigues Steven W · Manteca, CABuilt 1956 · S/N 410 N2750GLo Pilato Family Flights Inc · Wilmington, DEBuilt 1972 · S/N 6059 N2755BBoyce Aviation Inc · New Port Richey, FLBuilt 1965 · S/N 1541-105 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 N2828SSuburban Air Express Inc · Fairbanks, AKBuilt 1963 · S/N 1329-14 N289GRAerocomm LLC · Kalispell, MTBuilt 1959 · S/N 795 N290MPSuburban Air Express Inc · Fairbanks, AKBuilt 1965 · S/N 1535-104 N292SMartin James David · Graford, TXBuilt 1976 · S/N 3274 N29PRGa Flying LLC · Kalispell, MTBuilt 1969 · S/N 6018 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 N309VSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 1659-128 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 N3341Klitzke Lucanus E · La Plata, NMBuilt 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 N37CKRichardson Dean · Saint Thomas, VIBuilt 1962 · S/N 500A-1251-76 N3836CAdvanced Airways Inc · Loxahatchee, FLS/N 791 N3846CCrowder Eston W · Dade City, FLS/N 709 N385CGOwensboro Warehouse Leasing LLC · Owensboro, KYBuilt 1965 · S/N 1495-14 N39GWKotalite Consultant LLC · West Palm Beach, FLS/N 3096 N3UVPonderosa Aviation LLC · Safford, AZBuilt 1973 · S/N 3146 N401MGLeff William J · Dayton, OHBuilt 1965 · S/N 1527-29 N410THHardy Hole Drilling LLC · El Paso, TXS/N 1790-20 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

Back to AD 94-04-13