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.

N70075Kennel Isaac John · Salt Lake City, UTBuilt 1976 · S/N 28-7790177 N7007JKeltner Kody M · Meadville, PAS/N 28-3162 N7007WBiros Timothy D · Nya, MNBuilt 1962 · S/N 28-682 N7008FSouthbound Aviation LLC · Jackson, TNBuilt 1976 · S/N 32-7740012 N7008RPerchall Theodore G II · Fort Myers, FLBuilt 1966 · S/N 28-21701 N7009RJackson Donald W · Carthage, MSS/N 28-21702 N700FMWahl Mark E · Oswego, NYBuilt 1972 · S/N 28-7225187 N700GCRicks Auto Clinic Inc · Raytown, MOBuilt 1977 · S/N 32-7740054 N700WPLebus Jack G · Longview, TXBuilt 1979 · S/N 32-7940085 N7010FEconomou Michael · Falls Church, VAS/N 32R-7780051 N7010WBrown Nicholas R · Knoxville, TNS/N 28-687 N7011JSouthlake Aviation LLC · Arden, NCBuilt 2016 · S/N 2843821 N7011WLevine Allen D Trustee · Goshen, NYBuilt 1962 · S/N 28-688 N7012RPalomo Joe · Laredo, TXBuilt 1966 · S/N 28-21706 N7014WSpi Group LLC · Georgetown, TXS/N 28-694 N7015WHunt Timothy J · Mesa, AZBuilt 1962 · S/N 28-695 N7016FNations One For Christ · Duluth, MNS/N 32R-7780052 N7016WDoorenbos Rodney J · Washburn, MOBuilt 1962 · S/N 28-696 N7017RRd Aire LLC · Opelika, ALBuilt 1966 · S/N 28-21712 N7017WLong Matt · Watsonville, CABuilt 1962 · S/N 28-698 N7018RMccauley Lauren M · Severance, COBuilt 1966 · S/N 28-21713 N7018WArnold Richard C · Fitchburg, MABuilt 1962 · S/N 28-699 N7019RMidland Flyers LLC · Warrenton, VABuilt 1966 · S/N 28-21714 N701CAMkc Aviation LLC · St George, UTBuilt 1973 · S/N 28R-7435107 N701DCBlack Cat Aviation LLC · Indianapolis, INBuilt 1973 · S/N 28R-7435020 N701DTWilliamson Flying Club Inc · Williamson, NYBuilt 1971 · S/N 28-7125415 N701EAPratt Thomas · Muncie, INBuilt 1973 · S/N 28R-7435036 N701FLInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N 28-7225213 N701RALaith Aviation LLC · Goose Creek, SCBuilt 1973 · S/N 28R7335415 N7020RJwe Aviation LLC · Sugar Hill, GABuilt 1966 · S/N 28-21715 N7020WDavila Antonio · Cudjoe Key, FLBuilt 1962 · S/N 28-702 N7021WRichardson Garrett W · Mason, MIBuilt 1962 · S/N 28-703 N7022WHall Wesley B · Hot Springs, ARS/N 28-704 N7023RPushpull LLC · Montgomery, TXS/N 28-21719 N7025CDowning Gregg R · Guymon, OKBuilt 1975 · S/N 28-7690050 N7025WBerberich Edward C · Gillette, NJBuilt 1962 · S/N 28-709 N7026RSanderson Eric R · Chelan, WABuilt 1966 · S/N 28-21722 N7026WAdvanced Aviation Inc · Lakeville, MNBuilt 1962 · S/N 28-710 N70275Christiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843823 N7028RCuckler Jason Michael · Jenks, OKBuilt 1966 · S/N 28-21725 N7028WBlakely Richard S · Yerington, NVBuilt 1962 · S/N 28-712 N7029RBazzi Adel · Yorba Linda, CABuilt 1966 · S/N 28-21726 N7029WUSA Aircraft Leasing LLC · Dover, DES/N 28-686 N702RASmtm Holdings Inc · Wilmington, DEBuilt 1974 · S/N 28-7415475 N7030RAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1966 · S/N 28-21727 N7031CWestern New York Flying Club Inc · Bowmansville, NYBuilt 1975 · S/N 28-7690051 N7031WEarl Hittle Aero Inc · Greenville, OHBuilt 1962 · S/N 28-713 N7032WFleming William P · Tomah, WIBuilt 1962 · S/N 28-715 N7033FNaugler Winsor III · Fort Washington, PABuilt 1976 · S/N 28-7725084 N7033WRegistered aircraftN-number assigned, not yet registeredS/N 28-716

Back to AD 87-08-08 R3