Skip to content

Registered aircraft · 47,138

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

N206SNDye Seed Ranch Inc · Spokane Valley, WABuilt 1979 · S/N U20605101 N206SPHayden Scott · Anchorage, AKBuilt 1965 · S/N P206-0111 N206SUNorton Edward H · New York, NYBuilt 1976 · S/N U20603184 N206SVBremmer Randy R · Whitewater, COBuilt 1967 · S/N P206-0460 N206SXLaughlin Audio Video Electric Inc · Santa Ynez, CABuilt 1966 · S/N P206-0316 N206TDHomestead Helicopters Inc · Missoula, MTBuilt 1964 · S/N 206-0242 N206TMPale Horse LLC · Mishawaka, INBuilt 1975 · S/N E-775 N206TTThorson Thomas R · Wasilla, AKBuilt 1977 · S/N U20603772 N206TZTeton Leasing LLC · Polatello, IDBuilt 1979 · S/N U20605165 N206USKandle Douglas A · Boise, IDBuilt 1974 · S/N U20602628 N206VTSend North · Anchorage, AKBuilt 1967 · S/N U206-0993 N206WBOffice Of Aviation Services · Boise, IDBuilt 1973 · S/N U20602058 N206WDCritical 32 Degrees LLC · Milton Freewater, ORBuilt 1984 · S/N U20606832 N206WPMorrison Richard Lee Trustee · Anchorage, AKBuilt 1980 · S/N U20605897 N206WTSevere Clear Aviation LLC · Hagerstown, MDBuilt 1976 · S/N U20603613 N206WWSouthern Seaplanes LLC · Osteen, FLS/N U20604525 N206XKennedy Benjamin · Boulder, COBuilt 1968 · S/N P206-0479 N206XLVaughn Chris · Decherd, TNBuilt 1975 · S/N U20603035 N206XPAirborne Flyer LLC · Ashland, NHBuilt 1983 · S/N U20606701 N206YARantzair Inc · East Wenatchee, WABuilt 1965 · S/N P2060065 N206YSPalmer Ronald Everett Trustee · Hopkington, NHBuilt 1979 · S/N U20604652 N20706Ahf Investments LLC · Ruston, LABuilt 1972 · S/N 18261142 N20708Viersen Leonard J Trustee · Glennallen, AKBuilt 1972 · S/N 18261144 N20709Superior Fresh LLC · Idaho Falls, IDBuilt 1972 · S/N 18261145 N2070GAerobus LLC · Des Moines, IABuilt 1958 · S/N 51370 N2070KRudy Schmitt · Brookshire, TXBuilt 1964 · S/N 206-0196 N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753 N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037 N2070WLeisure Air II LLC · Columbus, GABuilt 1965 · S/N TC-974 N2070XNrt LLC · Maple Valley, WAS/N 18256170 N20713Spradling Tommy G Jr · Campbell, TXBuilt 1972 · S/N 18261148 N2071GGroarke Michael J · Marion, MTS/N 51371 N2071WCountry Sunset LLC · Mc Louth, KSBuilt 1966 · S/N CD-987 N2071YRossiter Brahm J · Lemoore, CABuilt 1997 · S/N E-3120 N20725Smith James M · Burbank, WABuilt 1972 · S/N 18261157 N2072GMccullough Russell O · Carson, CABuilt 1958 · S/N 51372 N2072WNewsome Jeff · Blackwell, OKBuilt 1965 · S/N D-8001 N20730Tantiyatyanon Preeda · Flagstaff, AZBuilt 1972 · S/N 18261162 N20735Porter H Tom · Columbia, MSBuilt 1972 · S/N 18261165 N20738Acquafly Creation LLC · Apopka, FLS/N 18261168 N2073GShepard Brothers LLC · Columbia, MSBuilt 1958 · S/N 51373 N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73 N2073RWindler Steven D · Owasso, OKBuilt 1964 · S/N 18255273 N2073WPlowden William E Jr · Shelby, NCBuilt 1965 · S/N D-8003 N20740Registered aircraftBuilt 1972 · S/N 18261170 N20743Eagles Flight LLC · Grove, OKBuilt 1972 · S/N 18261172 N2074LTb7 LLC · Kalispell, MTBuilt 1976 · S/N TC-1975 N20751Donovan John A W · Wellesley, MABuilt 1972 · S/N 18261178 N20755Sale Reported · Wichita, KSSale reportedBuilt 1972 · S/N 18261181 N20757Johnson Mark B · Etna, CABuilt 1972 · S/N 18261183

Back to AD 2000-23-21