Skip to content

Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N3830WKris Noone Air LLC · Wilmington, DES/N 32-764 N38311Archair Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 28-7790538 N38312Barnes Carl A · Jacksonville, FLS/N 28-7725261 N38313Lwr LLC · Teton, IDBuilt 1977 · S/N 28-7725262 N38315Meyer Lynn O · Olathe, KSBuilt 1977 · S/N 28-7725275 N38316Meriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7716241 N38319Fronduto Cody Michael · Fort Pierce, FLBuilt 1977 · S/N 28-7790539 N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138 N3831PPerkins Jason T · Hudson, MEBuilt 1955 · S/N 22-3521 N3831ZFloats N Hoes LLC · Umatilla, FLBuilt 1961 · S/N 18-7574 N38324De Oliveira Antonio J · Fuquay Varina, NCBuilt 1977 · S/N 28-7790535 N3832TFrysinger Melvin D · Weatherford, TXBuilt 1967 · S/N 28R-30150 N3832ZHoward Gary O · Eagle, AKBuilt 1961 · S/N 18-7575 N38331Johnston Craig J · Ocean City, NJBuilt 1977 · S/N 32-7740082 N38333Sonex Aircraft LLC · Oshkosh, WIBuilt 1941 · S/N 6943 N38334Gsm Air LLC · Old Tappan, NJBuilt 1977 · S/N 32R-7780415 N38338Rafter W Ranches LLC · Johnson, KSBuilt 1977 · S/N 32R-7780416 N3833QDowning Robert · Talent, ORBuilt 1971 · S/N 17259933 N3833WKurz Sean H · Blairsville, PABuilt 1966 · S/N 32-767 N3833ZDominguez Carlos L · Gainesville, GABuilt 1961 · S/N 18-7576 N3834RK J Aviation LLC · Jasper, INBuilt 1970 · S/N 28-5828 N3834TJsl Instructional Services LLC · Fort Worth, TXS/N 28R-30152 N38356John Prosock Machine Inc · Quakertown, PABuilt 1977 · S/N 28-7790543 N38357Carr Mark · Wshngtn Ct Hs, OHS/N 28-7790544 N3835THuber Charles H · Medina, OHBuilt 1967 · S/N 28R-30153 N3835VJones Scott L · Hilliard, OHBuilt 1957 · S/N 18693 N38368Dubisar Milo Richard · Redmond, ORBuilt 1977 · S/N 32R-7780419 N3836CAdvanced Airways Inc · Loxahatchee, FLS/N 791 N3836KValarchi Air Aviation LLC · Lewes, DEBuilt 1967 · S/N 28-23743 N3836WOconnell Richard M · Dothan, ALBuilt 1966 · S/N 32-771 N3836ZTroutman Charles W · Lincoln City, ORBuilt 1960 · S/N 18-7588 N38373Outbound Aviation LLC · Dover, DEBuilt 1977 · S/N 28-7716247 N3837EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960067 N3837PPlancich Don A · Sterling, AKS/N 14-154 N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937 N3837TRemsberg Charles · University Place, WABuilt 1967 · S/N 28R-30155 N3837ZTroutman Charles Wayne · Lincoln City, ORBuilt 1960 · S/N 18-7589 N38382Syracuse Aviation LLC · Cicero, NYBuilt 1977 · S/N 28R-7737091 N38388Hosanna Industries Inc · Gibsonia, PABuilt 1977 · S/N 32R-7780422 N3838EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960068 N3838PArlins Aircraft Service Inc · Belgrade, MTBuilt 1955 · S/N 22-3528 N3838TFundamentals Aircraft Leasing LLC · Erie, PABuilt 1967 · S/N 28R-30157 N3838ZWoldow Fredric A · Morton, ILBuilt 1960 · S/N 18-7592 N38394Wall Jeffrey L · Goffstown, NHBuilt 1977 · S/N 28-7790548 N3839EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960069 N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397 N3839PMorris Equipment LLC · Yuma, AZBuilt 1955 · S/N 22-3529 N3839TN3839t LLC · Copley, OHS/N 28R-30158 N3839ZPrax Philip G · Fairbanks, AKFirst renewal noticeBuilt 1961 · S/N 18-7593 N383BHAero Aircraft 13 LLC · Jacksonville, FLBuilt 1974 · S/N 17264151

Back to AD 87-10-06 R1