Skip to content

Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N6016JPatterson Roland O · Semmes, ALBuilt 1971 · S/N A1500316 N6016RCosse Harold C · Vacaville, CABuilt 1965 · S/N 17253685 N6016TStone Isaac L · Cushing, MNBuilt 1964 · S/N 15060716 N60172Mchugh-Lemasteers Ronna · Salem, ORS/N 15070122 N60173Skypark Inc · Wadsworth, OHBuilt 1968 · S/N 15070123 N60174Pham Hieu · Goodyear, AZBuilt 1968 · S/N 15070124 N60175Strange William H · Lewiston, IDFirst renewal noticeBuilt 1968 · S/N 15070125 N60177Kelley Robert D · Barstow, CABuilt 1969 · S/N 15070126 N60179Steen Jason D · Clark, SDBuilt 1968 · S/N 15070127 N6017ARidgeway Daniel M · Kalama, WAS/N 28617 N6017BBarrett Daniel E · Augusta, MTBuilt 1957 · S/N 34017 N60183Hobbs Cody J · Omak, WAS/N 15070130 N60184Beaver Jason A · Reno, NVS/N 15070131 N60188N7010v LLC · Shelby, NCBuilt 1969 · S/N 15070134 N6018AKing Andrew O · Newport, MEBuilt 1956 · S/N 28618 N6018BMcgrath Robert J · Simpsonville, SCBuilt 1957 · S/N 34018 N6018JGagnon Nels D · Globe, AZBuilt 1972 · S/N A1500318 N60191Vogt Jeffrey D · Pleasant Grove, CABuilt 1968 · S/N 15070136 N6019AMitman John J · Florence, MTBuilt 1956 · S/N 28619 N6019BHaderlie Dustin D · Afton, WYBuilt 1957 · S/N 34019 N6019GAgaliotis Paul E · San Martin, CABuilt 1969 · S/N 15071519 N601JRJumbo Gabrielle Inc · Wilmington, DEBuilt 1969 · S/N 15071513 N601MBRegistration Pending · Ridgely, MDRegistration pendingBuilt 1967 · S/N 18258550 N601NSchneider Bernard M · Battle Ground, WABuilt 1957 · S/N 32987 N601PAMendenhall Michael L · Douglasville, GABuilt 1977 · S/N 17269030 N601RFPearson Nils C · Englewood, FLBuilt 1975 · S/N 18052560 N602Watkins Arlo S · Chandler, AZBuilt 1963 · S/N 15060073 N60203Mike Smith Aviation International Inc · Napa, CABuilt 1969 · S/N 15070142 N60205Garza Gilberto · Yuma, AZBuilt 1969 · S/N 15070144 N6020ADanielson Donald J · Walla Walla, WABuilt 1956 · S/N 28620 N6020GBuckley Michael J · Billings, MTBuilt 1969 · S/N 15071520 N6020NWatts Carl · Thousand Oaks, CABuilt 1978 · S/N 21062888 N6020RFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 17253689 N60215Yoder Johnathan · Thompson Falls, MTBuilt 1969 · S/N 15070149 N60217Grensky Stephen R · Spokane, WABuilt 1969 · S/N 15070150 N6021RBechtold Richard · Broadlands, VABuilt 1966 · S/N 17253690 N60224Arc Aviation LLC · Frisco, TXBuilt 1969 · S/N 15070153 N60226Weston Jesse S · Spokane, WABuilt 1969 · S/N 15070155 N60227Ryan James E · Calvin, WVBuilt 1969 · S/N 15070156 N60228Greene James W · Brunswick, GAS/N 15070157 N6022BArpino James E · Fairbanks, AKBuilt 1957 · S/N 34022 N6022RCunningham Gene Jr · Bristol, VABuilt 1965 · S/N 17253691 N6022THenderson Beverly A · Sharon Springs, KSBuilt 1964 · S/N 15060722 N60233C-150j LLC · Manchester, MIBuilt 1969 · S/N 15070161 N6023JR&M Steel Co · Caldwell, IDBuilt 1972 · S/N A1500323 N60249Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 15070170 N6024JHangar 5 LLC · Wilmington, DEBuilt 1972 · S/N A1500324 N60250Camelot Aviation LLC · Wilmington, DEBuilt 1969 · S/N 15070171 N60254Holladay Aviation LLC · Jacksonville, FLBuilt 1969 · S/N 15070175 N60257Ouzounov Kaloian G · North Miami, FLBuilt 1969 · S/N 15070177

Back to AD 87-20-03 R2