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.

N9011WKrauser Peter · Saint Petersburg, FLBuilt 1965 · S/N 28-10593 N9012KDerbyshire William · Davie, FLBuilt 1977 · S/N 28R-7803057 N9012WPolybrown LLC · Massapequa, NYBuilt 1965 · S/N 28-10594 N9013WGrana Leonardo Javier · Huntersville, NCS/N 28-10596 N9015NPerry David · Campbell, CAS/N 28-4711 N9017JHarlan Tom L · Bakersfield, CABuilt 1966 · S/N 28-3045 N9017WHyde Charles G · Roanoke, TXBuilt 1965 · S/N 28-10601 N9018WPatzell Curtis J · Mandan, NDBuilt 1965 · S/N 28-10602 N9019QSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1975 · S/N 28-7615002 N901AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843801 N901BBVisual Group Inc · Tampa, FLBuilt 1974 · S/N 28R-7435256 N901BLMaritime Helicopters Inc · Homer, AKBuilt 1971 · S/N 32-7140030 N901BWKraft Tyrone H · Timber Lake, SDBuilt 1976 · S/N 32R-7680451 N901EHigh Five Flying LLC · Amarillo, TXBuilt 1973 · S/N 28-7425053 N901FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 2842171 N901PASkywest Leasing Inc · St George, UTS/N 2843481 N901TQAdirondack Aviation LLC · Saranac Lake, NYBuilt 1977 · S/N 28-7725178 N9021WHage Electric And Construction Services Inc · The Dalles, ORBuilt 1966 · S/N 28-10819 N9022JLewis Kristofor M · Sparks, NVBuilt 1966 · S/N 28-3050 N9022KRyczek Walter Alan · Huntersville, NCBuilt 1977 · S/N 28R-7803059 N9023JCook Richard J II · Princeton, ILBuilt 1966 · S/N 28-3051 N9025JAa&R Aviation LLC · Pine Grove, PABuilt 1966 · S/N 28-3053 N9025WCarlson Joshua G · Frazee, MNBuilt 1965 · S/N 28-10613 N9026JRay Adam W · Stinnett, TXBuilt 1966 · S/N 28-3054 N9027FErickson Jon D · Atwater, MNBuilt 1976 · S/N 28-7715299 N9027WAg Air Squadron One LLC · Saint Joseph, ILBuilt 1965 · S/N 28-10617 N90289Kuhlman Construction Company · Colesburg, IAS/N 32-7840101 N9028JGarcia Pinedo Adolfo · Miami, FLBuilt 1966 · S/N 28-3055 N9028KVan Duzer Peter John · Greenville, WIS/N 32-7840025 N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174 N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530 N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058 N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059 N9032WPringle Craig Marlin · Winfield, KSS/N 28-10624 N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062 N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063 N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066 N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184 N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067 N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185 N903EESkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843229 N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175 N903HWJackson Construction Services LLC · Wichita Falls, TXBuilt 1973 · S/N 32-7340068 N903USSchneider Charles · Sioux Falls, SDBuilt 1966 · S/N 28-3068 N903WBauer Power LLC · Russellville, ARS/N 28-10608 N9040JEllis James E Trustee · Harvard, MABuilt 1966 · S/N 28-3070 N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186 N9042JRenfroe Charles R · Panama City, FLBuilt 1966 · S/N 28-3073 N9043JHunter Lauchlin S Jr · Alexander City, ALS/N 28-3074 N9043WKaufman William D · Shelburn, INBuilt 1965 · S/N 28-10635

Back to AD 87-08-08 R3