Registered aircraft · 268

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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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:87-21-07-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.

N234WMBay Area Skymaster LLC · Pasadena, MDBuilt 1962 · S/N 500A-1257-81 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 N274LECsonka Bela · Hesperia, CABuilt 1962 · S/N 500A-1232-69 N2750BRodrigues Steven W · Manteca, CABuilt 1956 · S/N 410 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 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 N368TPDonohue Andrew · Tulsa, OKBuilt 1973 · S/N 12039 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 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 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 N411VVScott William H · Mount Pleasant, SCS/N 520-39 N411WRForbes Greg · Placerville, CAS/N 1505-19

Back to AD 87-21-07 R1