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.

N5860VAlasc Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 28R-7737072 N5861ULasc Aviation Inc · Callaway, FLBuilt 1970 · S/N 28-26692 N5863UReithaar Max R · Clinton, WABuilt 1970 · S/N 28-26695 N5864UBoehm William Dean · Baldwin, ILBuilt 1970 · S/N 28-26696 N5864VPlainte Christopher S · Prudenville, MIBuilt 1977 · S/N 28-7710041 N5864WAmerican Heritage Aviation LLC · Jacksonville, FLBuilt 1965 · S/N 28-2387 N5865URuehl Charles R · Gulf Shores, ALBuilt 1970 · S/N 28-26697 N5865WA L Aviation LLC · Boiling Springs, SCBuilt 1965 · S/N 28-2398 N5866UNicholson Troy B · Franklinton, LABuilt 1969 · S/N 28-26698 N5866WCapitol City Aviation Inc · West Sacramento, CABuilt 1965 · S/N 28-2427 N5868VSiefken Arnold G · Jamestown, NDBuilt 1977 · S/N 32R-7780369 N5868WAshton Paul D · Shelby Township, MIBuilt 1965 · S/N 28-2444 N586FLAce Aircraft Leasing Inc · Nazareth, PABuilt 1971 · S/N 28-7125444 N586KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843917 N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1999 · S/N 2843297 N586SBKareon Consulting LLC · Wilmington, DEBuilt 1966 · S/N 28-10781 N5870UWhite Thomas A · Roanoke, TXBuilt 1970 · S/N 28-26702 N5870VHagerstown Regional Aero Club · Dallastown, PABuilt 1977 · S/N 32R-7780370 N5873WPropst David A · Exchange, WVS/N 28-2503 N5874UFlying Wright Aviation LLC · Henderson, NVS/N 28-26707 N5875UTews Jamie S · Greenville, WIBuilt 1970 · S/N 28-26708 N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209 N5876U3shahs Aviation LLC · Temecula, CAS/N 28-26709 N5876WKiss George C · Bangor, PAS/N 28-2552 N5877FFeldvary John · Jackson, MIBuilt 1976 · S/N 28-7715155 N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505 N5878UAlbright Jasper N · Raleigh, NCBuilt 1970 · S/N 28-26710 N5878VVoll Douglas W · Watford City, NDS/N 28-7790506 N5878WWorrell Wayne · Campbellsville, KYBuilt 1965 · S/N 28-2555 N5879UJacobs Levon Jr · Oak Hill, FLBuilt 1970 · S/N 28-26713 N587KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843928 N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517 N5880VStevens Thomas G · Missoula, MTS/N 28R-7703158 N5880WDurkin Michael T · Sunland, CABuilt 1965 · S/N 28-2570 N5881URegistered aircraftBuilt 1970 · S/N 28-26715 N5881VNomotsa LLC · Buena Vista, COS/N 28R-7703160 N5882FGo Fly Mi LLC · Saginaw, MIBuilt 1976 · S/N 28-7790140 N5882UMartinez Guillermo E · Upland, CABuilt 1970 · S/N 28-26716 N5884UB & R Aircraft LLC · Wadsworth, OHS/N 28-26719 N5886FBacktoeden LLC · Casper, WYBuilt 1976 · S/N 28-7790141 N5887UFretz Richard G · Harrisburg, PABuilt 1970 · S/N 28-26722 N5888ULynch Francis X · Dumont, NJBuilt 1970 · S/N 28-26755 N5889VJust Plane Fun LLC · Lac Du Flambeau, WIBuilt 1977 · S/N 28-7790507 N5889WHarrison Joshua · Canyon Country, CABuilt 1965 · S/N 28-2627 N588BSMeives Mark J · Barneveld, WIBuilt 1978 · S/N 32R-7887140 N588LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020106 N5890UKempton Lana Julia Trustee · Douglasville, GABuilt 1970 · S/N 28-26786 N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508 N5891U2dwh LLC · Katy, TXBuilt 1970 · S/N 28-26727 N5891WMarino Mario Mennona · King Of Prussia, PABuilt 1965 · S/N 28-2633

Back to AD 87-08-08 R3