Skip to content

Registered aircraft · 564

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:89-18-02-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:89-18-02-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:89-18-02-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:89-18-02-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:89-18-02-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:89-18-02-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.

N8380KHeimgartner Aviation LLC · Juliaetta, IDBuilt 1982 · S/N 676B N8386Hershey Flying Service Inc · David City, NES/N 884 N8386KBuntings Dusting Inc · Berlin, MDS/N 678B N8388Williams Clarence E · Biggs, CABuilt 1972 · S/N 880 N8388KBellamy Mark A · Freeville, NYS/N 679B N8400KVincent Flying Service Inc · Kaplan, LABuilt 1982 · S/N 685B N8405KStorm Flying Service LLC · David City, NEBuilt 1982 · S/N 688B N8412KSutter Butte Dusters · Live Oak, CAS/N 690B N8422KWells Garry · Scotia, NES/N 80B N8429KVincent Flying Service Inc · Kaplan, LABuilt 1982 · S/N 692B N842WAHaley Flying Service Inc · Tracy, CABuilt 1986 · S/N 775B N8444KZumwalt Adam · Sheldon, ILBuilt 1983 · S/N 716 B N8448KAlaska Air Service LLC · Brookings, ORS/N 698B N8449KZumwalt Adam · Sheldon, ILBuilt 1982 · S/N 699B N8481KBowles Flying Service · Live Oak, CABuilt 1982 · S/N 706B N8483KAir Enterprises LLC · Dover, DES/N 708B N8486KBasin Aviation · Rio Oso, CABuilt 1982 · S/N 709B N8494KHaley Flying Service Inc · Tracy, CABuilt 1983 · S/N 713B N8497Curry Timothy S · Salisbury, MDBuilt 1972 · S/N 886 N8499KHatfield'S Spraying Service Inc · Nunica, MIBuilt 1982 · S/N 720B N84PGSpot-Air LLC · Burlington, TXBuilt 2005 · S/N 1536 N8515HMid Continent Aircraft Corp · Hayti, MOBuilt 1974 · S/N 1389 N8516HCompton Gerald H · Richvale, CABuilt 1975 · S/N 1391 N8535HKidd Clifford L · Monahans, TXBuilt 1975 · S/N 1399 N8549HAg Cat Aviation LLC · Faulkton, SDBuilt 1975 · S/N 1403 N8555HHoly Smoke Inc · Auburndale, FLBuilt 1975 · S/N 1405 N8623HTucker Nelson E DBA · Hartford, ALBuilt 1975 · S/N 1436 N8629HHershey Flying Service Inc · David City, NEBuilt 1975 · S/N 1438 N8638HAlbright Frank E · Elba, ALBuilt 1975 · S/N 1441 N8644HHulet Terence W · Perry, OKBuilt 1975 · S/N 1444 N8651HHayton James B · Sedro Woolley, WAS/N 1446 N8677HSprague Robert J · Courtenay, NDBuilt 1975 · S/N 1462 N8701HWestern Cooperative Co · Alliance, NEBuilt 1975 · S/N 1478 N8716HM & K Flying Service Inc · Hot Springs, ARBuilt 1975 · S/N 1499 N8718HStaas Justin W · Yuba City, CAS/N 1487 N8735HPhilipp Dean E · Thief River Falls, MNBuilt 1975 · S/N 1505 N8761HLejeune Aerial Applications LLC · Basile, LABuilt 1976 · S/N 1516 N8766HHershey Flying Service Inc · David City, NEBuilt 1975 · S/N 1522 N8779HMiller Wade W · Hot Springs, SDBuilt 1975 · S/N 1526 N8834HAg Air LLC · Raceland, LABuilt 1975 · S/N 1B N8851HClassic Arrow Inc · Hutchinson, MNS/N 1545 N8875HRichter Aviation Inc · Maxwell, CABuilt 1975 · S/N 1556 N8878HRiggin Flight Service Inc · Madison, SDBuilt 1975 · S/N 1558 N8916HEagle Vistas LLC · Williston, FLBuilt 1976 · S/N 1613 N8923HGrasso Kurt D · Bridgeton, NJBuilt 1975 · S/N 1567 N8943HYaggie Farm Service Inc · Breckenridge, MNBuilt 1975 · S/N 1579 N8948HCummins Aviation Services Inc · Lake Worth, FLBuilt 1975 · S/N 1582 N8950HLejeune Michael N Sr · Crowley, LABuilt 1975 · S/N 1588 N8953HBlilie Dennis DBA · Walcott, NDBuilt 1975 · S/N 1590 N8957HBuntings Dusting Inc · Berlin, MDS/N 1592

Back to AD 89-18-02 R1