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.

N9315JKruthoff Bret · Charles City, IABuilt 1966 · S/N 28-3425 N9315NDiir County Flying Inc · Sturgeon Bay, WIS/N 28R-35015 N9316JStennis Aviation Group LLC · Mandeville, LABuilt 1966 · S/N 28-3409 N9316WPrettyman James M · Sykesville, MDBuilt 1967 · S/N 28-10997 N9318CTarakji Mohamad Hani A · Van Nuys, CABuilt 1978 · S/N 28-7890398 N9318JJohnson Matt · Eugene, ORBuilt 1966 · S/N 28-3411 N9319FNorris Aeroworks LLC · Port Orange, FLS/N 28-7715300 N9319JAcs Aviation LLC · Wilmington, DEBuilt 1966 · S/N 28-3427 N9319WHunt Dennis Jr · Marlboro, NJBuilt 1967 · S/N 28-11001 N931ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881511 N931FSM & M Aviation Services Ltd · Rock Falls, ILS/N 28R-7918230 N931GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881076 N9320NEagle Aviation Inc · Tucson, AZBuilt 1969 · S/N 28R-35020 N9320WManzo Anthony Michael · Fairmont, WVBuilt 1967 · S/N 28-11002 N9321CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 28R-7837191 N9321JR Goldburg LLC · Gastonia, NCBuilt 1966 · S/N 28-3414 N9321NRegistration Pending · Shreveport, LARegistration pendingBuilt 1969 · S/N 28R-35021 N9321WTriplett Joseph C II · Pontotoc, MSBuilt 1968 · S/N 28-11003 N9322JZollitsch Allan P · Lancaster, NYBuilt 1966 · S/N 28-3415 N9323CHangar 9 Inc · Aberdeen, SDBuilt 1978 · S/N 28R7803252 N9323JDaissaoui Anouar · Quincy, MABuilt 1966 · S/N 28-3416 N9323VRoll Douglas J · Bradenton, FLBuilt 1967 · S/N 28-11005 N9324JAdbdelsalam Moustafa · Buena Park, CABuilt 1966 · S/N 28-3417 N9324KBellew Philip H · Gadsden, ALBuilt 1976 · S/N 28-7690243 N9324WB2w Corp · Winona, MNBuilt 1967 · S/N 28-11007 N9325WStevens Daniel · Moss Point, MSBuilt 1968 · S/N 28-11008 N9328JRegistered aircraftBuilt 1966 · S/N 28-3422 N9328KSantoro Alexandre Jose · Mountain View, CABuilt 1976 · S/N 28R-7635232 N9328WLahm Robert E · Parish, NYBuilt 1968 · S/N 28-11011 N9329JBradford Earl · Fairview, MIFirst renewal noticeBuilt 1966 · S/N 28-3423 N9329NWang Huafei · Cupertino, CABuilt 1969 · S/N 28R-35029 N932ECRegistration Pending · Panama City, FLRegistration pendingBuilt 2021 · S/N 2881512 N932GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881077 N9330JTinaga Resorts Corp · San Angelo, TXS/N 28-3424 N9330WMarcy Michael S · Farmington, NMBuilt 1968 · S/N 28-11014 N9331JSkysight Consulting LLC · Memphis, TNBuilt 1966 · S/N 28-3428 N9331WBallou Wesley S · Houston, TXS/N 28-11015 N9332JKnutson Wayne R · Thompson, NDBuilt 1966 · S/N 28-3429 N9332NSloan Donald W · Dover, DEFirst renewal noticeBuilt 1969 · S/N 28R-35032 N9332WWicker Kevin N · Beechgrove, TNBuilt 1967 · S/N 28-11016 N9333JRau Alan · Java, SDBuilt 1966 · S/N 28-3430 N9333NGlendale Community College · Glendale, CABuilt 1969 · S/N 28R-35033 N9334CBadzinski James P · Roseville, MNBuilt 1978 · S/N 28-7816461 N9334NRoberson Ronald M · High Ridge, MOBuilt 1969 · S/N 28R-35040 N9336WForbes Eric L · Pahrump, NVBuilt 1968 · S/N 28-11021 N9337CLovett Zachary · Fort Worth, TXBuilt 1978 · S/N 28-7816462 N9337JHudson Kenneth J · Caswell Beach, NCBuilt 1966 · S/N 28-3434 N9337KSkyrise Aviation Corp · Pompano Beach, FLBuilt 1976 · S/N 28-7625176 N9337NHoward Robert L · Jacksonville, NCBuilt 1969 · S/N 28R-35037 N9338CSmart4 LLC · Kissimmee, FLBuilt 1978 · S/N 28-7816463

Back to AD 87-08-08 R3