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.

N7715NK Heart Aviation LLC · Choudrant, LABuilt 1968 · S/N 28-5162 N7715WFoster Kenneth D · Saint Maries, IDBuilt 1964 · S/N 28-1720 N77160Fahmy Bishoy F · Fraser, MIBuilt 1973 · S/N 28-7425111 N7716JQuinn Andrew · Fort Worth, TXBuilt 1969 · S/N 32-1118 N7716NPyanov Mark · Clinton, MSS/N 28-5163 N7716WWood Burton T · Richmond Hill, GABuilt 1964 · S/N 28-1721 N7717JFlying High Aviation LLC · Kalispell, MTBuilt 1969 · S/N 32-1119 N7717NAdirondack Flying Club LLC · Rome, NYBuilt 1968 · S/N 28-5160 N7717WFouse Timothy · Kittanning, PABuilt 1964 · S/N 28-1722 N7718JPrcs Logistics LLC · South Bound Brook, NJBuilt 1969 · S/N 32-1120 N7718NKlinedinst D Eric · Carlisle, PABuilt 1968 · S/N 28-5027 N7718WClyde Fliers Inc · Fremont, OHBuilt 1964 · S/N 28-1724 N7719JMaduro Dudley C · St Thomas, VIFirst renewal noticeBuilt 1969 · S/N 32-1121 N7719WKnudson Douglas E · Morris, ILBuilt 1964 · S/N 28-1725 N771CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881739 N771LMBruntjen Eric · Decatur, ILBuilt 1982 · S/N 32R-8229044 N771NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881036 N771PCBuzzair Inc · Wilmington, DEBuilt 1966 · S/N 32-391 N771PTPilot Training Center LLC · Miami, FLBuilt 2000 · S/N 2844027 N771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 2841154 N771WSCampbell Reginald G · Hilo, HIS/N 28-24767 N7720J3c Aviation Lc · Clare, MIS/N 32-1122 N7720WLagrange LLC · East Helena, MTBuilt 1964 · S/N 28-1726 N7721CRenfro Jacqueline L · Bethel, AKBuilt 1975 · S/N 32R-7680060 N7721NRome Nicholas S · Olathe, KSBuilt 1969 · S/N 28-5167 N7721WKosobud Timothy J · Adams, WIBuilt 1964 · S/N 28-1727 N7722WKratzer Ernest W · Castaic, CABuilt 1964 · S/N 28-1729 N7723JHabig Robert D · Sheridan, INBuilt 1969 · S/N 32-1125 N7723NFord Charles D · Clifton, TNFirst renewal noticeBuilt 1968 · S/N 28-5166 N7725NHangar Twenty Two Aviation LLC · Athens, TXBuilt 1968 · S/N 28-5169 N7726WJrw Flight LLC · Huntsville, MOBuilt 1964 · S/N 28-1733 N7727WAukee Isaac J · Ironwood, MIBuilt 1964 · S/N 28-1734 N7728JClear Skies Leasing LLC · Okemos, MIBuilt 1969 · S/N 32-1130 N7728NP-Factor Aviation LLC · Hoover, ALBuilt 1969 · S/N 28-5172 N7728WSchrage Kevin J · Trevor, WIBuilt 1964 · S/N 28-1735 N7729CPeterman Keith · Taylorsville, KYBuilt 1975 · S/N 28-7625082 N7729JMorris Roy S · Shorter, ALBuilt 1969 · S/N 32-1131 N772CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881740 N772FTJazz Air LLC · Melbourne, FLBuilt 2000 · S/N 2844029 N772NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881037 N772SDWallace Robert L II · Anderson, SCBuilt 1978 · S/N 32R-7887246 N772VBSkybone Airline Academy Inc · Vero Beach, FLBuilt 2023 · S/N 28020105 N772WSSouthwest Technology Center School District No. 27 · Altus, OKBuilt 1967 · S/N 28R-30083 N7730CBug'Z Land Clearing LLC · Pensacola, FLBuilt 1975 · S/N 28-7615062 N7730WSuh Y H Charles · Rowland Heights, CABuilt 1964 · S/N 28-1738 N7731JBattaglia Gregory · Debary, FLBuilt 1969 · S/N 32-1134 N7731NThompson Randy L · Anderson, CAS/N 28-5174 N7732WWoodhead James R · Charleston, SCBuilt 1964 · S/N 28-1740 N7733NS Dacy Enterprises Inc · Harvard, ILBuilt 1968 · S/N 28-5176 N7733WSwyers Stinson R · Ottsville, PABuilt 1964 · S/N 28-1741

Back to AD 87-08-08 R3