Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N836TBEast Of Nowhere Aviation LLC · Highland, UTBuilt 2000 · S/N 18280735 N8370QState Of Alaska Dept Of Fish And Game · Palmer, AKBuilt 1976 · S/N U20603231 N8370SBerti Robert Cord · Wilton, CABuilt 1965 · S/N 18256470 N8371SLamm Matthew S · Morristown, NJS/N 18256471 N8372MCollins Delbert Ray · Talihina, OKBuilt 1976 · S/N 18264597 N8373SBart Bruno Paul · Monterey, CABuilt 1965 · S/N 18256473 N8374Q8374q LLC · Gig Harbor, WABuilt 1976 · S/N U20603235 N8375SAero Glide Corporation · Sedona, AZBuilt 1965 · S/N 18256475 N8378QAeroworks Of Alaska LLC · Chugiak, AKBuilt 1976 · S/N U20603239 N8378SGulley Ronald L · Boise, IDBuilt 1965 · S/N 18256478 N8378ZKling Jeffrey V · Friendswood, TXBuilt 1963 · S/N 205-0378 N8379SAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 18256479 N837GACampbell Stephen V · Farmingdale, NYS/N 182-67338 N8381SUer LLC · Searcy, ARBuilt 2018 · S/N 18283035 N8381ZVoran Carlon R · Port Alsworth, AKBuilt 1963 · S/N 205-0381 N8382SFitzwater Richard B · Athol, IDBuilt 1965 · S/N 18256482 N8385ZHoneysett Robert E Jr · Anchorage, AKS/N 205-0385 N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520 N8386QLe Tourneau University · Longview, TXBuilt 1976 · S/N U20603247 N8386SDavis Lawrence R · Kent, OHS/N 18256486 N8388MGreater Chattanooga Aviation Club LLC · Chattanooga, TNBuilt 1976 · S/N 18264601 N8388SRose Mary R · Portland, ORBuilt 1965 · S/N 18256488 N8389SGriffith Kevin D · Lakeview, MIBuilt 1965 · S/N 18256489 N838MMZhang Li · Palo Alto, CABuilt 2018 · S/N 18283049 N838PGHinton Michael B · Hesperia, CABuilt 1974 · S/N 18263090 N8390ZJp Aero Holdings Inc · Carson City, NVBuilt 1963 · S/N 205-0390 N8391ZSkelton Thomas W · Holt, MIBuilt 1963 · S/N 205-0391 N8392SCooksey Dustin J · Strasburg, COBuilt 1965 · S/N 18256492 N8393SMast Aviation LLC · Roseburg, ORBuilt 1965 · S/N 18256493 N8393ZDeal Enterprises Inc · Doran, MNBuilt 1963 · S/N 205-0393 N8394QPacific Union College · Angwin, CABuilt 1976 · S/N U20603255 N8394ZRegistered aircraftBuilt 1963 · S/N 205-0394 N8396SRegistration Pending · Livingston, MTRegistration pendingBuilt 1965 · S/N 18256496 N8397QSeattle Seaplanes LLC · Seattle, WABuilt 1976 · S/N U20603258 N8397ZFlying H LLC · Lake Placid, FLBuilt 1963 · S/N 205-0397 N8398SRoberts Rickey J · Kamiah, IDBuilt 1965 · S/N 18256498 N8399SDenver Aviation Inc · Westminster, COS/N 18256499 N83BMShelton David B · Dallas, TXBuilt 1983 · S/N 21064799 N83CBDenton William P · Dallas, TXBuilt 1978 · S/N 18052992 N83JVClark Jason · Gig Harbor, WABuilt 1983 · S/N 18268329 N8402TNalty Shannon P · Queen Creek, AZBuilt 1959 · S/N 52302 N8402ZRixford Raymond Gould · Gunnison, COBuilt 1963 · S/N 205-0402 N8404TMichels Lon · Plentywood, MTBuilt 1959 · S/N 52304 N8404ZSmith Michael E · Willits, CABuilt 1963 · S/N 205-0404 N8405QVan Pelt Matthew · Challis, IDBuilt 1976 · S/N U20603265 N8406SSkydive Central New York LLC · Weedsport, NYBuilt 1965 · S/N 18256506 N8406ZBarsto Aviation Inc · Wilmington, DEBuilt 1963 · S/N 205-0406 N8407SRottinghaus Charles A · Waterloo, IABuilt 1965 · S/N 18256507 N8407TRegistration Pending · Norway, IARegistration pendingBuilt 1959 · S/N 52307 N8408ZRegistered aircraftBuilt 1963 · S/N 205-0408

Back to AD 84-10-01 R1