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.

N9862WWagler Randal Clarence · Bradenton, FLS/N 28-23377 N9863WRohde Bruce G · Fife, WABuilt 1967 · S/N 28-23379 N9864WDuell David J · Sparks, NVS/N 28-23380 N9867WBeuscher Sharon A · Fairborn, OHBuilt 1967 · S/N 28-23385 N9868WCarpenter Robert A · Westfield, NYBuilt 1967 · S/N 28-23386 N9869WJohnson Charles C · Fitzgerald, GABuilt 1967 · S/N 28-23387 N986FBBenzie Fred J III · Marquette, MIBuilt 1977 · S/N 28-7790074 N986GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881492 N9870WTaffin Air LLC · Mount Vernon, OHBuilt 1967 · S/N 28-23389 N9871KBeverly Flight Center LLC · Middleton, MABuilt 1977 · S/N 28-7816200 N9871WLemerande Alan Robert Jr · Jefferson City, MOBuilt 1967 · S/N 28-23390 N9872KWolvestown LLC · Humble, TXS/N 28-7816201 N9874KReintjes Byron · Fresno, CABuilt 1977 · S/N 28R-7803072 N9874WMcanally Cameron F · Battle Ground, WABuilt 1967 · S/N 28-23394 N9876KN9876k LLC · Rockledge, FLS/N 32R-7880038 N9876WFoster John D · Grapevine, TXBuilt 1967 · S/N 28-23396 N9878WBenton Michael L · Gilbert, SCBuilt 1967 · S/N 28-23398 N987DCLewis Michael · Anaheim, CABuilt 1980 · S/N 28R8031103 N987EGPensacola Navy Flying Club Inc · Pensacola, FLBuilt 1972 · S/N 28R-7335027 N987TDRegistered aircraftBuilt 1974 · S/N 28R-7535075 N9880WJuhl Aaron · Overland Park, KSBuilt 1967 · S/N 28-23400 N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192 N9884KSalt Air Inc · Wilmington, DEBuilt 1977 · S/N 32-7840031 N9886KSmart03 LLC · Kissimmee, FLBuilt 1977 · S/N 28-7816205 N9886WLathem Emma K · Amarillo, TXS/N 28-23406 N9888WSchlafer Antone · Lincoln, CABuilt 1967 · S/N 28-23408 N9889WFaix James M · Sarasota, FLBuilt 1967 · S/N 28-23409 N988AMM & G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 2881579 N988GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881493 N988JFMcdaniel Patrick D · State College, PABuilt 1999 · S/N 2843287 N9890KWilliams Robert · Dawsonville, GABuilt 1977 · S/N 28R-7837046 N9890WKoryciak Robert L · Boling, TXBuilt 1967 · S/N 28-23410 N9891WRegistration Pending · Orem, UTRegistration pendingS/N 28-10698 N9893KReuter Daniel · Cupertino, CABuilt 1978 · S/N 28R-7803079 N9893WSky High Aviation LLC · Streamwood, ILBuilt 1967 · S/N 28-23413 N9896Paul Chappano Pa · Saint Johns, FLBuilt 1976 · S/N 32R-7680184 N9896WKnapp Joseph E Jr · Clermont, FLBuilt 1967 · S/N 28-23416 N989ASSkupin Charles G · Riverview, MIBuilt 1978 · S/N 32-7840201 N989SRBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 3257268 N989TMPrestige Wordwide Km LLC · Lynn Haven, FLS/N 28-24164 N98CTRote William E · San Marcos, CABuilt 1965 · S/N 3222 N98DBDb Aero Restoration LLC · Wilmington, OHBuilt 1977 · S/N 28-7790474 N98HSSaunders Robert A · Barrington, RIBuilt 1997 · S/N 2843086 N98JFYls Aviation LLC · Bozeman, MTBuilt 2001 · S/N 3257247 N98JGDistrict Board Of Trustees Miami Dade College Fl · Miami, FLBuilt 1969 · S/N 28R-35117 N98LAEwa LLC · Redding, CABuilt 1998 · S/N 3257031 N98MSSparks Carl A · Branson, MOBuilt 1976 · S/N 28-7615175 N98MVFargo Jet Center LLC · Fargo, NDBuilt 1995 · S/N 28-90216 N98PFDakota Acre Farms Inc · Denhoff, NDBuilt 1985 · S/N 28-8516044 N98TLAir Dynamics LLC · West Des Moines, IABuilt 1998 · S/N 3257061

Back to AD 87-08-08 R3