Registered aircraft · 18,497

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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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:86-13-04-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.

N210PWPapa Whiskey Aviation LLC · Huntsville, ALBuilt 1981 · S/N 21064343 N210PZKmz Centurion LLC · San Mateo, CABuilt 1976 · S/N 21061268 N210RMace Steven B · Ocala, FLBuilt 1967 · S/N D-8463 N210RBLibrary Interiors Of Florida Inc · Auburndale, FLBuilt 1982 · S/N 21064716 N210REValiair Lc Trustee · Casper, WYS/N P21000846 N210RPRegistration Pending · Charlestown, INRegistration pendingBuilt 1978 · S/N P21000014 N210RZKk Hangar LLC · Little Rock, ARBuilt 1971 · S/N 21059529 N210SCSpence C Jason · New Braunfels, TXBuilt 1967 · S/N 21058888 N210SDArdoin Robin C · Lafayette, LABuilt 1980 · S/N 21064225 N210SLKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N P21000129 N210SMMcconnell Peter · Valencia, PABuilt 1979 · S/N P21000370 N210SNDominguez Mark J · Many, LABuilt 1980 · S/N P21000548 N210SSVucich Bryant · Palm Beach Gardens, FLBuilt 1978 · S/N 21062997 N210SWSierra Whiskey Aircraft LLC · Saint Louis, MOBuilt 1975 · S/N 21061068 N210SYBluegrass Air Systems LLC · Nicholasville, KYBuilt 1979 · S/N 21063684 N210TRichard Brady K · Farmers Branch, TXBuilt 1978 · S/N 21062936 N210TECenturion Flyers LLC · Crystal Bay, NVBuilt 1975 · S/N 210-60544 N210TFAll About The Doodles Inc · Kirkland, ILS/N 21057793 N210TGDouble H Enterprises LLC · Bolivar, MOBuilt 1979 · S/N 21063530 N210THHeffley Terry · Granbury, TXBuilt 1976 · S/N 21061574 N210TJJaco Oil Company · Bakersfield, CABuilt 1980 · S/N 21063948 N210TPAirborne Enterprises LLC · Ava, MOBuilt 1979 · S/N 21063186 N210TRMora Ricardo A · El Paso, TXBuilt 1977 · S/N 21061745 N210TSGeary Inc · Westcliffe, COBuilt 1978 · S/N P21000128 N210TYRiley Charles · Littleton, COBuilt 1979 · S/N P210-00252 N210VBHoogendyk Robert · Big Bear City, CABuilt 1979 · S/N 21063776 N210VJV J Wings Inc · Wilmington, DES/N 21063387 N210VTStricker Andreas Daniel · Essex Junction, VTBuilt 1980 · S/N P21000522 N210VVHeesacker Stephen L Trustee · Los Altos, CABuilt 1979 · S/N 21063214 N210WCWeeks Curtis E · Cotulla, TXBuilt 1982 · S/N 21064759 N210WJRude Daniel · Leesburg, VABuilt 1982 · S/N 21064734 N210WLBskt210 LLC · Hartsville, SCBuilt 1981 · S/N 21064450 N210WMBryan-Kennedy LLC · Tulsa, OKBuilt 1963 · S/N 21058287 N210WSOlin David G · Jupiter, FLFirst renewal noticeBuilt 1969 · S/N 21059135 N210WTBarlowe James M · Enumclaw, WABuilt 1971 · S/N 21059528 N210WVHiservant Ministries Inc · Mont Belvieu, TXBuilt 1977 · S/N 21061852 N210WWInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N P21000808 N210WZHogue Tool & Machine Inc · Paso Robles, CABuilt 1973 · S/N 21060039 N210XPAnderson Andre A · El Paso, TXBuilt 1970 · S/N 21059336 N210XXRegistration Pending · Porter, TXRegistration pendingBuilt 1964 · S/N 21058402 N210YPartners Aviation LLC · Wilmington, DEBuilt 1970 · S/N 210-59260 N210ZPThaggard Aviation LLC · Leesburg, GABuilt 1975 · S/N 21060554 N210ZZCollins Michael P · Cordova, AKBuilt 1971 · S/N 18501866 N2110AWindshear Aviation LLC · Longmont, COBuilt 1977 · S/N TJ-129 N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761 N2110S2f Trade LLC · Gainesville, TXBuilt 1975 · S/N 21061074 N2111QKnapp Christian K · Lyons, COBuilt 1969 · S/N E-135 N2113FBunde Kermit A · Pocatello, IDBuilt 1964 · S/N U206-0313 N2113LGilbert Ben · Omaha, NEBuilt 1976 · S/N D-9917 N2116LHagg Theodoor · Johnson City, TNBuilt 1976 · S/N D-9916

Back to AD 86-13-04 R3