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.

N31407Montei Nicholas P · Caro, MIS/N 32-7840130 N3140GBynum Aviation LLC · New Albany, MSS/N 3257433 N3143JLyden Air LLC · Walbridge, OHBuilt 2006 · S/N 3257427 N3147DOrr Calvin L · Higginsville, MOBuilt 1968 · S/N 32-40412 N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439 N314JBBratton Johnny B · Williamsport, TNBuilt 1999 · S/N 2843226 N314LTJacobelli Raphael P · Norwalk, CTBuilt 1979 · S/N 28R-7918115 N314NETee Philip · Far Hills, NJS/N 287716112 N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031 N3151HD S R D Investments LLC · Oklahoma City, OKBuilt 2006 · S/N 3257428 N3152KPiper 52k LLC · Middleton, MAS/N 2842272 N31531Storey James F · Gadsden, ALBuilt 1978 · S/N 28-7816558 N31532Delaware Valley Aviation Inc · Langhorne, PABuilt 1978 · S/N 28-7890468 N31536Island Air Taxi LLC · Put In Bay, OHBuilt 1978 · S/N 32-7840132 N3154WBrolan Aviation LLC · Kansas City, MOS/N 2842273 N3155SSterling Flight Training LLC · Jacksonville, FLBuilt 1978 · S/N 28-7890525 N31563Hfd Aviation LLC · Salem, VABuilt 1978 · S/N 28-7816561 N31565Datema Steven K · Susanville, CABuilt 1978 · S/N 28-7816563 N31569Snyder Bradley R · Johnstown, PABuilt 1978 · S/N 32-7840133 N31571Cg Air LLC · Mason City, IABuilt 1978 · S/N 32-7840134 N31573Miller Gerald L · Selinsgrove, PABuilt 1978 · S/N 32R-7885103 N31581Lesher Jesse L · Walton, KYBuilt 1978 · S/N 28-7816565 N31583Redel Michael R · Gasquet, CABuilt 1978 · S/N 28-7890470 N31589Redemption Leasing LLC · Kodiak, AKBuilt 1978 · S/N 32-7840135 N31592Pharr Jonas · Benton, LABuilt 1978 · S/N 32R-7885107 N31593N31593 LLC · Key West, FLBuilt 1978 · S/N 32R-7885108 N315EFMatherne Aviation · Houma, LABuilt 1979 · S/N 28-8016155 N315VRegistered aircraftBuilt 1977 · S/N 28-7790440 N31600Florida 7771 Aviation Assets LLC · Lakeland, FLBuilt 1978 · S/N 28-7816566 N31602Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1978 · S/N 28-7890471 N31604Sun Mountain Flying LLC · Cody, WYBuilt 1978 · S/N 28R-7803288 N31608Hall Larry Brent Jr · Charlottesville, VABuilt 1978 · S/N 32R-7885110 N31609Kbb Aviation LLC · Prairie Grove, ARBuilt 1978 · S/N 32R-7885111 N3161TKoester Carsten · San Jose, CAS/N 28R-7235144 N31630Harris Jeffrey M · Crossville, TNBuilt 1978 · S/N 28-7816568 N31632Mikerich LLC · Laguna Hills, CAS/N 28-7816569 N31634Ahmed Sharfaraz · Houston, TXS/N 28-7816570 N31636Terwilliger Michael P · Groveland, CABuilt 1978 · S/N 28-7890472 N3163QLakefield Lance Ltd · Coldwater, OHBuilt 1977 · S/N 32R-7780295 N31641Ruefer Fred · Muskogee, OKS/N 32R-7885113 N31642Gr8 Sky Aviation LLC · Calhoun, GABuilt 1978 · S/N 32R-7885114 N31649Runway Hero LLC · Wayland, MABuilt 1978 · S/N 28R-7837241 N31657Wynne Kenneth H · Branford, CTBuilt 1978 · S/N 32-7840139 N31661Mosley Ken · Westlake Village, CABuilt 1978 · S/N 32R-7885117 N31669Navy Annapolis Flight Center Inc · Edgewater, MDBuilt 1978 · S/N 28-7816574 N31678Dodson International Parts Inc · Rantoul, KSS/N 32R-7885119 N31694Rey Al · Burlington, NCBuilt 1978 · S/N 28R-7837244 N31699Donahue Investments LLC · Port Orange, FLBuilt 1948 · S/N 32-7840142 N316APAntofiami Flying Circus Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680210 N316BT316 Bravo Tango LLC · Austin, TXS/N 28-7305433

Back to AD 87-08-08 R3