Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N8435UMayotte Robert · Boynton Beach, FLS/N 28-8290005 N84364Innovated Control Systems Inc · Watsonville, CABuilt 1981 · S/N 28-8290008 N84366Noeldner Pamela Ann · Lansdale, PABuilt 1981 · S/N 32R-8113113 N84368N84368 LLC · Colorado Springs, COBuilt 1981 · S/N 32R-8129105 N8436JMarshall Lee C · Hartsville, SCBuilt 1981 · S/N 28-8116320 N8436RRegistration Pending · Riverton, KSRegistration pending, pending cancellationBuilt 1966 · S/N 28-22316 N8436TElias Akal Aviation LLC · Deering, NHBuilt 1981 · S/N 28-8116321 N8436WHidalgo Robert J · El Paso, TXS/N 28-2667 N8437CRobert Price Smith · Hodgenville, KYBuilt 1976 · S/N 28-7690141 N8437WThomas Eric D · Placerville, CABuilt 1965 · S/N 28-2668 N8438EBohlen Terry A · Cameron Park, CABuilt 1982 · S/N 28-8211001 N8438HPitt Ian · Bergenfield, NJS/N 28-8290009 N8438RMorrison Doyle T · Goldthwaite, TXBuilt 1966 · S/N 28-22319 N8439EManchin Joseph III · Charleston, WVBuilt 1981 · S/N 32R-8113115 N8439TFly Quest Aviation LLC · Pomona, CAFirst renewal noticeBuilt 1981 · S/N 28-8290012 N8439WPace Andrea · Homosassa, FLBuilt 1965 · S/N 28-2670 N8439ZSyracuse Flying Club Inc · Fayetteville, NYBuilt 1981 · S/N 28-8190313 N843SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881717 N84400N84400 LLC · Chamblee, GABuilt 1981 · S/N 28-8216004 N8440BKoon Anthony Scott · Kokomo, INBuilt 1981 · S/N 28-8290013 N8440FMarsh John E · Washington, DCS/N 32-7740023 N8440HMeyer Anthony R · Whittemore, IABuilt 1981 · S/N 28-8216001 N8440MAirflair Inc · Maurice, IABuilt 1981 · S/N 28-8216002 N8440WPensa Way Inc · Pensacola, FLBuilt 1965 · S/N 28-2671 N8441CCirrus Aviation Inc · Easton, PABuilt 1981 · S/N 28-8290014 N8441HEuroair Consultants LLC · Vero Beach, FLBuilt 1981 · S/N 28-8290015 N8441MAmick David E · Elizabethtown, PABuilt 1981 · S/N 28-8290016 N8441WGeaney Kacy B · Alturas, CABuilt 1965 · S/N 28-2672 N8442ADillehay David · League City, TXBuilt 1981 · S/N 28-8211006 N8442HWhited Grant Trustee · Petaluma, CABuilt 1981 · S/N 32-8106098 N8442LChappell Johnathan · Santa Barbara, CABuilt 1981 · S/N 32R-8113117 N8442PCbfd LLC · Northampton, PABuilt 1981 · S/N 32R-8113119 N8442RBandon Aviation LLC · Bandon, ORBuilt 1966 · S/N 28-22325 N8442WInspire Aviation LLC · Magnolia, TXBuilt 1965 · S/N 28-2675 N8443RKor Aviation LLC · Piedmont, SDBuilt 1966 · S/N 28-22326 N8443WFew Tyus S · Roanoke Rapids, NCBuilt 1965 · S/N 28-2676 N8444BLutz Christine A · Acton, CABuilt 1981 · S/N 28-8290024 N8444DEtheredge Mark · Pell City, ALBuilt 1981 · S/N 28-8216012 N8444JHeartland Ag Aviation LLC · Lancaster, KSBuilt 1981 · S/N 28-8216013 N8444SVertex Aviation Services LLC · Burlington, WABuilt 1982 · S/N 28-8290025 N8444WShowalter Robert B · Orlando, FLBuilt 1965 · S/N 28-2677 N8445ADowntown Goldsmith & Engraving · Deland, FLBuilt 1981 · S/N 28-8290027 N8445BStarnes Robert · Vandervoort, ARBuilt 1981 · S/N 28-8216016 N8445GStauffer David R · Boise, IDS/N 28-8216017 N8445HOracle Aviation LLC · Omaha, NEBuilt 1981 · S/N 28-8216018 N8445RTakeoff Power Aviation And Media Solutions Inc · San Juan, PRBuilt 1966 · S/N 28-22329 N8445SWifa (Washington International Flight Acad) LLC · Gaithersburg, MDBuilt 1981 · S/N 28-8216022 N8445XCrossbrook LLC · Willoughby, OHBuilt 1981 · S/N 28-8290032 N84467Lewin Robert · Essex Fells, NJBuilt 1981 · S/N 28-8190257 N8446BBas Part Sales LLC · Greeley, COBuilt 1981 · S/N 28R-8231001

Back to AD 87-08-08 R3