Skip to content

Registered aircraft · 72,001

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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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.

N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227 N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506 N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929 N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930 N21323A2t Guys Aviation LLC · Williamston, MIBuilt 1978 · S/N 28-7916033 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216 N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448 N2132XChampionx LLC · Sugar Land, TXBuilt 1998 · S/N 27-0250 N2133ASchnack Kenneth L · Crescent, IAS/N 32R-7987007 N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217 N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1978 · S/N 28-7916144 N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180 N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218 N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467 N2134SC Squared Inc · Stevensville, MDBuilt 1979 · S/N R18201307 N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142 N2134WJustison David L · Hillsboro, ILBuilt 1974 · S/N M-1508 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N21352Lane Shannon L · Hopkinsville, KYBuilt 1978 · S/N 32R-7885252 N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202 N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203 N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110 N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188 N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139 N21360Weede Roger H · Dubois, WYS/N 17263935 N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292 N2136CPope Keith D · Mineral Wells, TXBuilt 1978 · S/N 28-7911022 N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219 N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253 N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368 N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111 N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N2137EMbg LLC · Mountain Home, IDBuilt 1997 · S/N 27-0230 N2137FColakoglu Migirdic · Hilton, NYBuilt 1978 · S/N 28-7911048 N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138BSouthwest Aviation Enterprises · Haslet, TXBuilt 2003 · S/N T20608437 N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065 N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070 N2138NJ T Air Inc · Dayton, MDBuilt 1979 · S/N 28-7911094 N2138PRedwood Barry Lindon · Forest, VABuilt 1956 · S/N 23-729 N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646 N2139BN2139b LLC · Newark, DEBuilt 1978 · S/N 28-7911009 N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220 N2139KPolly P LLC · Fort Worth, TXBuilt 1999 · S/N 27-0271

Back to AD 87-10-06 R1