Skip to content

Registered aircraft · 54,015

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.

N60832Pharmacures Inc · Catasauqua, PABuilt 1969 · S/N 15070608 N60835Jet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 15070610 N60836Avz Aviation Of Tennessee Inc · Knoxville, TNBuilt 1969 · S/N 15070611 N60837Howard James S · Arlington, TXS/N 15070612 N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677 N6083FConservation Services LLC · Sheridan, WYBuilt 1975 · S/N 18264098 N6083JB&R Aircraft LLC · Wadsworth, OHBuilt 1980 · S/N 17273853 N6083RHatle Arlen J · Meadow, SDFirst renewal noticeBuilt 1965 · S/N 17253752 N6083VScholz Francis M · Atchison, KSBuilt 1980 · S/N 172RG0571 N60844Ayres Roger A · Henderson, NVS/N 18504062 N60846Erickson Daniel W · Tomales, CAS/N 15070615 N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678 N6084JHatloy Mark · Drayton, NDBuilt 1973 · S/N A1500384 N6084MGrider Charles H III · Belleville, ILBuilt 1980 · S/N 15284615 N6084RKdb Flying LLC · Branchville, SCBuilt 1965 · S/N 17253753 N6084TRipper Ryan · Howell, MIBuilt 1964 · S/N 15060784 N60855Douglas Raymond M · Hamilton, NYBuilt 1969 · S/N 15070622 N6085MWood Mark D Trustee · New Berlin, WIBuilt 1980 · S/N 15284616 N6085TUllmayer Claressa L · Murray, UTBuilt 1964 · S/N 15060785 N60860Joebravo Aviation LLC · Derby, KSBuilt 1969 · S/N 15070627 N60861Hansen Aviation LLC · Savannah, GAS/N 15070628 N60865Breitberg Benjamin D · Ridgecrest, CABuilt 1969 · S/N 15070631 N6086AWatson Johnna A · Sonoma, CABuilt 1956 · S/N 28686 N6086GAbovestandard LLC · Denison, TXBuilt 1979 · S/N 17273566 N6086JSiegel Quarry LLC · Versailles, MOBuilt 1975 · S/N 18263628 N6086SDos Lobos Aviation LLC · Yankton, SDBuilt 1980 · S/N R18201610 N6086TCampbell Jack G · Spring Valley, WIBuilt 1964 · S/N 15060786 N60870Stracener Adam K · Pittsburg, TXBuilt 1969 · S/N 15070635 N60871Young Greg W · Knoxville, TNBuilt 1980 · S/N 18504067 N60875Registration Pending · Soldotna, AKRegistration pendingBuilt 1969 · S/N 15070638 N60878Barnett Shawn N · Hartsfield, GABuilt 1969 · S/N 15070639 N6087AFlood Plain Farm And Mercantile LLC · Curlew, WABuilt 1956 · S/N 28687 N6087BAzure Farms Inc · Dufur, ORBuilt 1957 · S/N 34087 N6087FKozub Matthew P · Exeter, RIBuilt 1975 · S/N 18264102 N6087JTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1973 · S/N A1500387 N6087RPalmenteri Winston D · Rhome, TXS/N 17253756 N6087TGray Bryan D · Colorado City, TXBuilt 1964 · S/N 15060787 N60880Walsh Michael B · Gates, TNBuilt 1969 · S/N 15070641 N60883Dubaj Louis F · Spring Hill, FLBuilt 1969 · S/N 15070644 N60884Norton Keith H · Oro Valley, AZBuilt 1969 · S/N 15070645 N60888Somerville Nicholas · Saint Augustine, FLBuilt 1969 · S/N 15070647 N60889Law Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1969 · S/N 15070648 N6088AStrickland Vernon G · Fort Worth, TXBuilt 1956 · S/N 28688 N6088ERacoon Aviation LLC · San Antonio, TXS/N 18268343 N6088GGreat Lakes Air Ventures LLC · Mason, MIBuilt 1969 · S/N 15071588 N6088HWright Duane · Sanford, FLS/N 15284129 N6088JCummings David · Grand Junction, COS/N 18263629 N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141 N6088RPruette Jason · Oakland, CABuilt 1965 · S/N 17253757 N60892Moyers Steven J · Carrollton, KYBuilt 1969 · S/N 15070650

Back to AD 87-20-03 R2