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.

N8088XSky 66 Aero LLC · Talala, OKBuilt 1961 · S/N 17248588 N80896Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17266793 N80899Pedersen Herbert N · Willard, UTFirst renewal noticeS/N 15067399 N8089ESkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 17272138 N8089FFlying A Aviation LLC · Archer City, TXBuilt 1966 · S/N 15064189 N8089GWellman Steven R Trustee · Englewood, FLBuilt 1971 · S/N 177RG0089 N8089SBleier Rachel · Grayslake, ILBuilt 1965 · S/N 15061689 N8089TGonzaez Richard · Granbury, TXBuilt 1960 · S/N 17556789 N808BCMahanawai Lele LLC · Honolulu, HIBuilt 1970 · S/N 18260273 N808DMRhoads Timothy C · Logan, NMS/N 18268443 N808ESStaples Safari Ministries Outreach · Clayton, WAS/N 15064164 N808FSBradley Supply Company LLC · Mesquite, NVS/N 21061586 N808KSDucks Are Free LLC · Salina, KSBuilt 1967 · S/N 15067436 N808RLCtr Assets LLC · Dawsonville, GABuilt 1963 · S/N 205-0467 N808UFMahoney Clinton D · Tecumseh, NEBuilt 1975 · S/N 17264869 N80906Red Door Aviation LLC · Dover, DEBuilt 1976 · S/N 17266796 N80912Bay Area Concrete LLC · Hayward, CABuilt 1976 · S/N 17266798 N80914Cp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17266799 N8091AHonrud Joseph C · Cal Nev Ari, NVBuilt 1952 · S/N 20943 N8091EChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172-75486 N8091GWood Kim W · Tucson, AZBuilt 1971 · S/N 177RG0091 N8091LSzarek Carlee B · Los Osos, CABuilt 1967 · S/N 17256291 N8091ZFahlbusch Marius J · Snohomish, WABuilt 1966 · S/N U206-0491 N80921Conerly Group LLC · Denham Springs, LABuilt 1976 · S/N 17266803 N80928Bellingham Aviation Services LLC · Bellingham, WABuilt 1976 · S/N 17266804 N8092BHering Robert A · Anchorage, AKBuilt 1957 · S/N 29892 N8092TFlying Colors Airparts Inc · Leesburg, FLBuilt 1961 · S/N 17556792 N8092VRohm Arne · Miller, MOBuilt 1974 · S/N A1500526 N80931Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266806 N8093FHardy Peter Nicholas · Los Osos, CABuilt 1966 · S/N 15064193 N8093LNevins Mark B · Gresham, ORBuilt 1967 · S/N 17256293 N8093TScholl Adam J · Garretson, SDBuilt 1960 · S/N 17556793 N80941Holombo Ray J · Taylors, SCBuilt 1976 · S/N 17266810 N8094BRutherford County Air Rescue Squad · Rutherfordton, NCBuilt 1957 · S/N 29894 N8094GTri Rotor Spray & Chemical · Ulysses, KSBuilt 1973 · S/N 18801230 N8094TMapes Rocky A · Thornton, COS/N 17556794 N8094XJenkins Matthew · Bend, ORS/N 17248594 N80952Registered aircraftBuilt 1976 · S/N 17266817 N80959Mets Flying Club Inc · Fairmount, INBuilt 1976 · S/N 17266819 N8095BYeagley Daun E III · Moraine, OHBuilt 1957 · S/N 29895 N8095SKimball James D · Osceola, IABuilt 1965 · S/N 15061695 N8095TCarter Audie L · Port Saint Lucie, FLFirst renewal noticeBuilt 1960 · S/N 17556795 N8095XBall Christopher B · Homer, AKBuilt 1961 · S/N 17248595 N80961A S Air LLC · Lantana, FLBuilt 1976 · S/N 17266820 N8096TSchoonover Emma L · Wichita Falls, TXBuilt 1960 · S/N 17556796 N80975N80975 LLC · Wilmington, DEBuilt 1976 · S/N 17266821 N8097FBlue Sky Powers LLC N8097f LLC · Dover, DES/N U2060497 N8097LPeters Aero Plus LLC · Freeland, MIBuilt 1967 · S/N 17256297 N8097XKublank Nathan S · Sun Prairie, WIBuilt 1961 · S/N 17248597 N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825

Back to AD 87-20-03 R2