Skip to content

Registered aircraft · 22,413

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.

N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318 N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529 N2886TAtkins Joseph Van · Lenoir, NCBuilt 1972 · S/N 28-7225268 N2886XMiller Robert Joseph · Fence Lake, NMBuilt 1979 · S/N 28-7990530 N2887DTwelve Bits LLC · Fort Lauderdale, FLBuilt 1979 · S/N 28R-7918197 N2887QAvalon Global Aviation Inc · Lakeland, FLS/N 28R-7918199 N2887TSanetra George W · Gary, INBuilt 1972 · S/N 28-7225269 N28887Danos Laura S · Hampton Falls, NHBuilt 1979 · S/N 28-7990432 N2888CGutwein Harvey R · Francesville, INS/N 28-7911225 N2888GClark Larry K · Sedalia, COBuilt 1979 · S/N 28-7911226 N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153 N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433 N2889GValkyrie Holdings LLC · Lincoln, NES/N 28-7911228 N2889QAshworth Mark · Stow, OHS/N 28-7921083 N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154 N288AWilson Daniel T · Bandon, ORBuilt 1976 · S/N 32R-7680345 N288BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881751 N288CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881635 N288FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-23767 N288GHBowen Christina M · Shreveport, LAS/N 28-1938 N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144 N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482 N288PASkywest Leasing Inc · St George, UTBuilt 2002 · S/N 2843502 N288WEAviators LLC · Edina, MNBuilt 1983 · S/N 32-8324008 N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434 N2890EHamilton Aerospace LLC · Lovettsville, VAS/N 28-7921086 N2891GIsland Air Taxi LLC · Put In Bay, OHS/N 32-7940183 N2891TVagias Janet Rose · Niceville, FLBuilt 1972 · S/N 28-7225270 N2891YCherry Hill Aviation Inc · Freetown, INS/N 32-7940185 N28926Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881233 N2892TScherman Dale M · Ottertail, MNBuilt 1972 · S/N 28-7225272 N28933Lewis Group Properties LLC · Apex, NCBuilt 1979 · S/N 32-7940123 N28934Johnson Grant M · Odessa, FLBuilt 1981 · S/N 32R-8129008 N28935Kremer Brian F · Iona, MNBuilt 1979 · S/N 32-7940124 N2893CChapel Hill Flying Club DBA · Sanford, NCS/N 28-7916517 N2893LKhalaf Maher · Canton, MIBuilt 1979 · S/N 28-7916520 N2893MRls Rental Co Inc DBA · Joplin, MOBuilt 1977 · S/N 28-7816321 N2893ZElite Aviation Of The Carolinas LLC · Tobaccoville, NCS/N 28-7990533 N28949Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881257 N2894BBarthell Burley O · Saint Johns, FLS/N 28-7990535 N2894MHernandez Michael A · Stockton, CABuilt 1977 · S/N 28-7816322 N28958Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881258 N28959Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881259 N2895CZeira Eldad M · Encinitas, CABuilt 1979 · S/N 28R-7918203 N2895DSaylor Edward T III · Mesa, AZS/N 28R-7918204 N2895LSam001 LLC · Miami Beach, FLBuilt 1979 · S/N 28R-7918205 N2895NSebion Michael I · Westby, WIBuilt 1979 · S/N 28R-7918206 N2895TSr Patel LLC · Meadville, PABuilt 1972 · S/N 28R-7235156 N28966Life Aviation LLC · Winston Salem, NCBuilt 1979 · S/N 28-7921026 N28967Flying Farmers LLC · Ogden, IABuilt 1979 · S/N 28-7921027

Back to AD 87-08-08 R3