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.

N211ASBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 20700259 N211ATGeorge'S Aerial Spraying Service Inc · Sutton, NEBuilt 1971 · S/N 18800834 N211AVN8191e LLC · Manassas, VABuilt 1979 · S/N 17272151 N211BAWojteczko Jason A · Derby, KSBuilt 1977 · S/N 17270071 N211CFGoudreau Sean · Mount Dora, FLBuilt 1978 · S/N 21063013 N211DXHalter Dudley M · Locust Grove, GAS/N 17265119 N211EWJtb Logistics LLC · Byars, OKBuilt 1966 · S/N 337-0443 N211HPN211hp LLC · Lantana, FLBuilt 1980 · S/N 17274152 N211KCPau Hana LLC · Wilmington, DEBuilt 1977 · S/N 18265645 N211LR & G Schatz Farms Inc · Lockeford, CABuilt 1979 · S/N 21063183 N211LCSuddarth Steven Craig · Edgewood, NMBuilt 1974 · S/N 21060364 N211PAPiedmont Air Services LLC · Helena, MTBuilt 1981 · S/N U20606415 N211PTCappe Investment Group LLC · Homestead, FLBuilt 1972 · S/N 17261023 N211SSherrifs Office Kane County Utah · Kanab, UTBuilt 1985 · S/N U20606916 N211SQRare Air Inc · Waterford, MEBuilt 1971 · S/N 18260755 N211SWOrion Aviation LLC · Jeffersonville, INBuilt 1977 · S/N 18503327 N211TSalazar Frank A · Los Angeles, CABuilt 1975 · S/N 15077046 N211TCMayer William P · Anchorage, AKS/N 185-1380 N211TKJaye Jeffrey S · Vacaville, CABuilt 1966 · S/N 18257295 N211WTBetelgeuse Aviation LLC · Houston, TXBuilt 1978 · S/N 177RG1321 N21201Delta Aviation Inc · Monticello, MNBuilt 1972 · S/N 18261481 N21202Diamond David Samuel Trustee · Truckee, CABuilt 1972 · S/N 18261482 N21203Provence Michael D · Fort Worth, TXS/N 18261483 N21205Hodl Partners LLC · Allen, TXBuilt 1972 · S/N 18261485 N21206Baird David W · Kanab, UTBuilt 1972 · S/N 18261486 N21207Burgess John H · Tower, MNS/N 18261487 N2120CQuilter Charles J II Trustee · Laguna Beach, CABuilt 1953 · S/N 16105 N2120FWare Brandie W · Nikiski, AKS/N U206-0320 N2120GSouthern Arizona Balloons Inc · Tucson, AZBuilt 1958 · S/N 51420 N2120ROda Mark E · Angola, INBuilt 1964 · S/N 18255320 N2120YSchwier Joyce M · Benton City, WAS/N 17249620 N2120ZHenry John M · Anchorage, AKBuilt 1963 · S/N 18051220 N21215Van Steenkist Grant · Spokane Valley, WABuilt 1972 · S/N 18261494 N21218Street Raymond E Jr Trustee · Palmer, AKBuilt 1976 · S/N 18503051 N21219Dubose Brian · West YorkshireBuilt 1972 · S/N 18261498 N2121GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1958 · S/N 51421 N2121LDl Contractors Inc · Rexburg, IDBuilt 1964 · S/N 18255370 N2121QSchardt James A · Garden Valley, CABuilt 1974 · S/N 177RG0521 N2121RDengler Phillip L · Bordentown, NJBuilt 1964 · S/N 18255321 N2121YMclanahan John P · Culpeper, VABuilt 1963 · S/N 17249621 N2121ZRegistered aircraftS/N 18051221 N21224Registration Pending · Brenham, TXRegistration pendingBuilt 1972 · S/N 18261499 N21227Fly21227 LLC · Charleston, WVBuilt 1972 · S/N 18261500 N2122CIrwin Dennis R · San Diego, CABuilt 1953 · S/N 16107 N2122SBobo Construction LLC · Pullman, WABuilt 1975 · S/N 21061084 N2122UAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800672 N21230Beggs Construction Inc · Salem, ORBuilt 1972 · S/N 18261502 N21236Gjedde David C · Morristown, TNBuilt 1972 · S/N 18261506 N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911 N21238Hatfield Derik L · Mesa, AZBuilt 1972 · S/N 18261508

Back to AD 87-20-03 R2