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.

N285TARegistration Pending · Augusta, KSRegistration pendingBuilt 1977 · S/N 28-7716239 N285ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881639 N2860CN2860c LLC · Lafayette, COS/N 28-7921074 N2860TSchmitz Nicholas S · East Lyme, CTBuilt 1972 · S/N 28-7205232 N28614Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843731 N2861HStalvey Daron K · Conway, SCS/N 28-7921077 N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147 N28627Key City Fliers Inc · Maquoketa, IAS/N 28-7990420 N2862APrecious Heir Holding Company LLC · Tucson, AZBuilt 1979 · S/N 28-7916486 N2862TReed Thomas F · Maize, KSS/N 28R-7235148 N2863MBaillie Ryan B · Hermitage, TNBuilt 1977 · S/N 28-7816318 N2863PGic Inc · Oneill, NEBuilt 1979 · S/N 28-7990504 N2863UEady Paul Clifford · Lakeside, CABuilt 1979 · S/N 28-7990505 N2863VBfree2fly LLC · Delaware, OHBuilt 1979 · S/N 28-7990506 N2864YAnderson Bruce A · Seville, OHBuilt 1979 · S/N 28-7911211 N28652J & N Aviation LLC · Marion, IAS/N 28-7990421 N2865RCarmel Aviation Inc · Boise, IDBuilt 1969 · S/N 28R-35308 N2865VDekker Paul R · Port Saint Lucie, FLS/N 28-7921044 N28667Rehberg Eric · Chattanooga, TNBuilt 1979 · S/N 28-7990422 N2866RCw Arborists Ltd · Sagaponack, NYBuilt 1969 · S/N 28R-35309 N2866TPacific Coast Air Museum · Santa Rosa, CAS/N 28-7225258 N2866WBowman Field Flying Club Inc · Louisville, KYBuilt 1979 · S/N 28-7916489 N2867AShinkle Robert P · Sugar Creek Twnshp, OHBuilt 1979 · S/N 28-7916491 N2867TN504fl LLC · Killeen, TXBuilt 1972 · S/N 28-7225259 N2867URegistered aircraftS/N 28-7916493 N2868TBooth Gregory · Ferriday, LAFirst renewal noticeBuilt 1972 · S/N 28-7205233 N2868WExecutive Flight Institute LLC · Murrieta, CABuilt 1979 · S/N 28-7990509 N2868YMobile Dev Group LLC · Fair Lawn, NJBuilt 1979 · S/N 28-7990511 N28693Velocity Air LLC · Lebanon, TNBuilt 1979 · S/N 32-7940121 N2869ASchulz Gary E · Merrill, WIS/N 28-7990512 N2869TBoone Susan J · Bastrop, TXBuilt 1972 · S/N 28R-7235149 N2869XCalifornia In Nice Inc · San Jose, CAS/N 28R-7931231 N286BGD&J Aviation LLC · Apopka, FLBuilt 2006 · S/N 2842259 N286HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 2844041 N286NDMorris Randall Sanford Hartnett · Fort Worth, TXBuilt 2000 · S/N 2844035 N28708Camacho David P · Macon, NCS/N 32-7940122 N2870ARodriguez Rafael Corrales · Miami, FLBuilt 1979 · S/N 28R-7931232 N2870LDewire Mark · Wilmington, NCS/N 28R-7931234 N2870TDohrenwend Michael P · Huntsville, ALBuilt 1972 · S/N 32-7200028 N2871CTaylor Brandon C · Prosper, TXBuilt 1979 · S/N 28-7921079 N2871DBullion Steven C · Terry, MSS/N 28-7921080 N2872DLeggio David R · Boyce, LABuilt 1979 · S/N 32-7940167 N2873LShelton Brad · Wildwood, MOBuilt 1979 · S/N 28R-7918188 N2873RMitchell Daniel E · Lubbock, TXBuilt 1969 · S/N 28R-35312 N2873TMmrrc LLC · Lighthouse Point, FLS/N 28-7911216 N2873UBaker Douglas R · Ann Arbor, MIS/N 32-7940171 N2873XJag III Aviation LLC · Clarksdale, MSS/N 32-7940172 N2874XMorin Joseph A · Fiskdale, MAS/N 28-7916496 N2874ZAdvanced Aviation Concepts LLC · Gainesville, FLBuilt 1979 · S/N 28-7916497 N2875BRas Aviation LLC · Elyria, OHBuilt 1979 · S/N 28-7916499

Back to AD 87-08-08 R3