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.

N9562WHub City Aviation Academy LLC · Lubbock, TXBuilt 1967 · S/N 28-22999 N9563WEastside Development Co Inc · Winfield, KSBuilt 1967 · S/N 28-23000 N9564CPowell David K · Edwardsville, ILBuilt 1978 · S/N 28-7890422 N9564JIrvin Stephanie Michelle · Jacksonville, FLBuilt 1966 · S/N 28-3699 N9565JNebeker Kayla Rae · Murrieta, CABuilt 1966 · S/N 28-3700 N9567WMiler Aaron L · Chambersburg, PABuilt 1967 · S/N 28-23005 N9568CMitchell Stephen D · Wichita, KSBuilt 1978 · S/N 28-7890423 N9568WSale Reported · Cimarron, KSSale reportedBuilt 1967 · S/N 28-23006 N956ACJpe Aviation LLC · Fairview, TXBuilt 1999 · S/N 3257109 N956CRCreamer Michael · Miami, FLBuilt 2002 · S/N 3257294 N956SAAir Statler LLC · Harbor Springs, MIS/N 28R-7435054 N9570JCharlie November Romeo LLC · Denver City, TXBuilt 1966 · S/N 28-3707 N9571JMeunier Barry · Rehoboth, MABuilt 1966 · S/N 28-3708 N9571KOtter Fly LLC · Maricopa, AZS/N 28-7615213 N9572CJet2jun LLC · Roanoke, VABuilt 1978 · S/N 32R-7885057 N9573WPyxl Sky LLC · Cogan Station, PABuilt 1967 · S/N 28-23013 N9575JJones Anthony J · North Royalton, OHBuilt 1966 · S/N 28-3712 N9575WMike Flying Service LLC · Terrell, TXBuilt 1967 · S/N 28-23015 N9576CMercer Paul A · Salida, CABuilt 1978 · S/N 28-7816497 N9576JWright Jason C · Thorntown, INBuilt 1966 · S/N 28-3713 N9576KClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1976 · S/N 28-7615215 N9577JBrown Dennis N · Bakersfield, CAS/N 28-3715 N9578JDesbien Paul D · Texhoma, OKBuilt 1966 · S/N 28-3716 N9579CVan Winkle Steven Russell · East Berlin, PABuilt 1978 · S/N 28-7890425 N9579JGarrity Richard R · Green Bay, WIBuilt 1966 · S/N 28-3717 N957DScott Crump Properties LLC · Jasper, ALBuilt 2002 · S/N 3257296 N957TSevern Valley Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 3246176 N9580JFrontier Adventure Flyers LLC · Colorado Springs, COBuilt 1966 · S/N 28-3718 N9580WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23025 N9582WBlomquist Kevin C · Kanab, UTS/N 28-23027 N9583JTevik Michael A · Provo, UTBuilt 1966 · S/N 28-3722 N9584JLow Wing LLC · Upland, CABuilt 1966 · S/N 28-3723 N9584WMitchell Gary N · Kansas City, KSS/N 28-23030 N9585CEldredge Matthew · Locust Grove, GABuilt 1978 · S/N 32R-7885058 N9585JHaj Aviation Inc · Cypress, TXNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 28-3724 N9585KPuetthoff Jan H · Mount Sterling, KYBuilt 1976 · S/N 32R-7680230 N9585WRandolph Richard A · Gallipolis, OHBuilt 1967 · S/N 28-23031 N9586JGeorge Neal E · Crestview, FLBuilt 1966 · S/N 28-3725 N9586WAlpha 3 LLC · Troy, KSBuilt 1967 · S/N 28-23032 N9587JScott Jeremy A · Newark, OHBuilt 1966 · S/N 28-3726 N9591JLea Brenda A · Merriam, KSBuilt 1966 · S/N 28-3730 N9592WDreamcatcher Aviation LLC · Austin, TXS/N 28-23040 N9593JPhillips Raymond A Jr · Vestal, NYBuilt 1966 · S/N 28-3732 N9593KShoham Aviation LLC · Richmond, TXBuilt 1976 · S/N 28-7625185 N9594CPassino Nicholas J · Latham, NYBuilt 1978 · S/N 28R-7837209 N9594JJensen Enterprises LLC · Iola, KSBuilt 1966 · S/N 28-3740 N9594WMiddlecoast Air LLC · Grand Rapids, MIBuilt 1967 · S/N 28-23044 N9595JMuller Chester E · Hayward, CABuilt 1966 · S/N 28-3741 N9596JAstraeos Aviation LLC · Salisbury, NCBuilt 1966 · S/N 28-3742 N9596WFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N 28-23046

Back to AD 87-08-08 R3