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.

N6355EMassey David A · Yuba City, CABuilt 1959 · S/N 46455 N6355KCiampa B Frank · Greenwood, INBuilt 1975 · S/N 15077661 N6355SLudmerer Victor J · Greenwood Lake, NYBuilt 1967 · S/N 15067155 N6355TBrazos Valley Flight Services LLC · College Station, TXBuilt 1984 · S/N R18201994 N63565Cape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 15077398 N63569Eastern Kentucky University · Richmond, KYBuilt 1981 · S/N 17275452 N6356AFetterolf Zachary D · Athol, IDBuilt 1956 · S/N 33156 N6356BStaudacher Nicholas R · Midland, MIBuilt 1957 · S/N 34256 N6356ENielsen James Patrick · Chugiak, AKBuilt 1959 · S/N 46456 N6356GBettega Gerald E · Lutz, FLBuilt 1970 · S/N 15071856 N6356STurner Dale W · Moore Haven, FLBuilt 1967 · S/N 15067156 N63575Christensen Koufax · Norman, OKBuilt 1975 · S/N 15077404 N63579Ollmann Paul W · Poplar Grove, ILBuilt 1977 · S/N 18052855 N6357DRice John Jr · Maddock, NDBuilt 1979 · S/N 17272743 N6357QCable Air Inc · Upland, CABuilt 1981 · S/N 15285235 N6357XMaanum Scott R · Park Rapids, MNBuilt 1980 · S/N U20605863 N63580Registration Pending · Newbury Park, CARegistration pendingBuilt 1975 · S/N 15077409 N6358ATop Aircraft Leasing LLC · Wilmington, DEBuilt 1956 · S/N 33158 N6358EStanford Point LLC · Kalispell, MTBuilt 1959 · S/N 46458 N6358FHarrison Zuzana · Albuquerque, NMBuilt 1975 · S/N 18264172 N6358SStancil Joseph E Jr · Eagle River, AKBuilt 1982 · S/N U20606557 N63595Beard Bruce H · Pocatello, IDBuilt 1977 · S/N 18052856 N63596Parke Helen M · Kent, WABuilt 1975 · S/N 15077416 N63598Hollrah Richard E · Enid, OKBuilt 1975 · S/N 15077417 N63599Burkel Robert G · Hemet, CABuilt 1975 · S/N 15077418 N6359ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 33159 N6359BRoss Stout Architect Inc · Indian Wells, CABuilt 1978 · S/N 21062749 N6359DFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17272745 N6359KMaierhoffer Henry F DBA · Sylvania, GABuilt 1975 · S/N 15077662 N6359WScarlett Cameron O · Madison, WIBuilt 1981 · S/N P21000757 N635CGLongstreth James E · Powhatan, VAS/N 18265386 N635MSpl Invest LLC · Chandler, AZBuilt 1964 · S/N 17252253 N635MMHsp Holdings LLC · Farmington, NMBuilt 1978 · S/N R18200700 N63605Lowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1975 · S/N 15077423 N63608Klug Brian V · Speonk, NYBuilt 1975 · S/N 15077425 N63609Filtenborg Daniel · Shelbyville, MIBuilt 1981 · S/N 17275455 N6360AClaiborne Howard · Cottonwood, CABuilt 1956 · S/N 33160 N6360NEdwards Construction Group LLC · Washington, MOS/N 18267830 N63610Frantz Paul · Palmyra, PABuilt 1975 · S/N 15077426 N63612St Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1981 · S/N 17275456 N63617Johnston Daniel · Virginia Beach, VAS/N 15077432 N63619Beard Jeffrey L · New Oxford, PABuilt 1975 · S/N 15077434 N6361FTramper Air LLC · Rockford, MIBuilt 1966 · S/N 337-0361 N6361GHalley Dan R · Avery, TXBuilt 1970 · S/N 15071861 N6361SSchade Scott · Green Valley, AZBuilt 1967 · S/N 15067161 N63620Florida Airplane Recovery LLC · Tallahassee, FLS/N 15077435 N63621Macgregor Sinclair · Oroville, CAS/N 15077436 N63626Nelson Matthew J · Frewsburg, NYS/N 15077439 N63628Black Hills Airplanes LLC · Rapid City, SDBuilt 1981 · S/N 17275458 N6362AMillican Clifford A · Burleson, TXBuilt 1979 · S/N 21063523

Back to AD 87-20-03 R2