Skip to content

Registered aircraft · 54,019

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N2176GWhite Robert G · Damascus, ORBuilt 1958 · S/N 51476 N2176QHawkins George W IV · Kansas City, KSBuilt 1974 · S/N 177RG0576 N2176YFischer James H · Wisconsin Rapids, WIBuilt 1962 · S/N 17249676 N21774Miller William A · Wallkill, NYS/N 17264016 N2177CRenaissance General Restoration Contracting · Madera, CABuilt 1978 · S/N 17702747 N2177GSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 51477 N2177RCalongne Michelle H · Cypress, TXS/N 18255377 N2177SFerkin Planes LLC · Caldwell, IDBuilt 1975 · S/N 21061138 N2177YNewbary Jason W · Missoula, MTBuilt 1962 · S/N 17249677 N21785Dibiaso Thomas F · Mount Laurel, NJBuilt 1974 · S/N 17264018 N2178CHowey Paul W · Stevensville, MDBuilt 1978 · S/N 17702748 N2178R2178 Romeo LLC · Pawlet, VTBuilt 1964 · S/N 18255378 N2178SAbbey Alyssa · Novato, CABuilt 1979 · S/N R18201310 N21791Colson Kevin A · Andover, KSBuilt 1974 · S/N 17264021 N21799Brownell John P Jr · Prattville, ALBuilt 1974 · S/N 17264025 N2179FKingdom Air Corps Inc · Sutton, AKBuilt 1965 · S/N U206-0379 N2179GAdonai International Ministries · Marine, ILBuilt 1958 · S/N 51479 N2179QHuston Jeffrey D · Haslet, TXBuilt 1974 · S/N 177RG0579 N217AFSouth 40th Rentals LLC · Jamul, CAS/N 177RG1011 N217AMSeven Alpha Mike LLC · Fredericksburg, TXS/N 18267300 N217CCWhite Hildery P Jr · Glendale, AZBuilt 1958 · S/N 51478 N217JAFlying Colors Airparts Inc · Leesburg, FLS/N 17275623 N217JLGallup Shelley P · Monterey, CABuilt 1971 · S/N 177RG0140 N217MMiles Manderson L · Lewiston, IDBuilt 1954 · S/N 31292 N217MEAir Research Ca Inc · Torrance, CABuilt 1983 · S/N T30300188 N21804Sharpe Alexander F · Camarillo, CABuilt 1974 · S/N 17264026 N21809Eckerson Dean H · Benicia, CABuilt 1974 · S/N 17264028 N2180CBerg Alvin L · Overgaard, AZBuilt 1955 · S/N 16165 N2180GGibson John M · Tiki Island, TXBuilt 1959 · S/N 51480 N2180SRawson Rodney L · Ellenton, FLBuilt 1961 · S/N 18253525 N21818Witthuhn Johnie B · Callaway, NEBuilt 1972 · S/N 18801058 N21819Middlesex Aviation Partners LLC · Bellingham, MABuilt 1974 · S/N 17264029 N2181EDbk Aviation LLC · Wilmington, DEBuilt 1982 · S/N 18268188 N2181FReese Percy C · Whitefish, MTS/N U206-0381 N2181GJohnson Sandra L · Eagle River, AKBuilt 1958 · S/N 51481 N2181ROflynn Christopher M · Woodland, WABuilt 1964 · S/N 18255381 N2181SGreer Kenneth R · Pittsburgh, PABuilt 1975 · S/N 21061142 N21827Hall William B · Tabernacle, NJFirst renewal noticeBuilt 1972 · S/N 18801063 N2182CSkyhunter LLC · Yonkers, NYS/N 17702749 N2182GCm Roberts LLC · Stratford, OKS/N 51482 N2182PSiemens Mark J · Rocklin, CABuilt 1976 · S/N 18264767 N2182RFoxley Brothers · Platte, SDBuilt 1964 · S/N 18256109 N2182SCimprich Michael J · Kirkland, WABuilt 1979 · S/N R18201311 N2182YWilson John M · San Antonio, TXBuilt 1962 · S/N 17249682 N21832Shuman Cecil R Trustee · Chugiak, AKS/N 18503069 N2183CVaughn Michael A Jr · Oxford, MIBuilt 1978 · S/N 17702750 N2183GBrinkman Jonathan D · Billings, MTS/N 51483 N2183QMcpherson Douglas G · Pennellville, NYS/N 177RG0583 N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031 N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032

Back to AD 87-20-03 R2