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.

N2506TTango LLC · Anchorage, AKS/N NAV-4-2506 N2506XBaumberger Gene C · Greenville, ILBuilt 1965 · S/N P206-0006 N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469T N2508SErnst Don A · San Luis Obispo, CABuilt 1976 · S/N 21061311 N2508XCaspaar Valentin · Seattle, WABuilt 1965 · S/N P206-0008 N2509TFarah Gregory · Meredith, NHBuilt 1968 · S/N NAV-4-2509 N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91 N250GWasalo And Luby Air LLC · La Fayette, GABuilt 1967 · S/N D-8600 N250MLAlpha Aero Repair LLC · Dousman, WIBuilt 1973 · S/N CE-475 N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261 N250TCGroth William B · Hixson, TNBuilt 1969 · S/N D-9048 N2510TN2510tango LLC · Corona, CABuilt 1968 · S/N NAV-4-2510 N2511XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 42063 N25120Waconda Concepts LLC · Sturgis, SDBuilt 1985 · S/N 46-8508097 N2512XKeesee Theodore A · Lavonia, GABuilt 2005 · S/N 42077 N2513TPettaway J Michael · Lake Charles, LABuilt 1968 · S/N NAV-4-2513 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2514THinkle Marcus E · Brazoria, TXBuilt 1968 · S/N NAV-4-2514 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2515TWoodside Jason S · Warrenton, VABuilt 1968 · S/N NAV-4-2515 N2517XBraun Robert M Trustee · Watkins, MNBuilt 2005 · S/N 42081 N2518TRivard Beauregard E · Shafer, MNBuilt 1968 · S/N NAV-4-2518 N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251 N2521TMoore Kevin B · Lancaster, VABuilt 1968 · S/N NAV-4-2519 N2522TLemons Lawson W · Crowell, TXBuilt 1967 · S/N NAV-4-2504 N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022 N2524TMetz Daniel J · Brighton, COBuilt 1969 · S/N NAV-4-2525 N2525KAvenue Enterprises Transportation LLC · Longboat Key, FLS/N 0890 N2525TPaliughi Ronald D · Fresno, CAS/N NAV-4-2521 N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803 N2526XBolin David A · Kenmore, WAS/N P206-0026 N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028 N252DLPlac Holdings LLC · Paradise, TXBuilt 1975 · S/N 310R0242 N252DPDream Flite LLC · Sarasota, FLBuilt 1973 · S/N TE-932 N252MASbkb Aviation LLC · Henderson, NVBuilt 2006 · S/N 29-0425 N252PDeck Air LLC · Kalamazoo, MIBuilt 2004 · S/N 1002 N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984 N252SWSymns Robert A · Aguila, AZBuilt 1978 · S/N 21063029 N252VKirschner Joel Trustee · Burbank, CABuilt 1971 · S/N CE-321 N2531QRegistered aircraftBuilt 1968 · S/N 185-1373 N2531TKilroy Edward J · Hernando, MSS/N NAV-4-2536 N2532SGrant Roderick M · Dillingham, AKBuilt 1973 · S/N 18502246 N2532XTwo River Airspray LLC · Hallock, MNBuilt 1964 · S/N P206-0032 N2533TMende Jeffrey · Crystal Lake, ILBuilt 1969 · S/N NAV-4-2533 N2536XLouscher Steven Trustee · Paullina, IABuilt 1964 · S/N P206-0036 N2537TBusiness Air Ventures LLC · Georgetown, DEBuilt 1970 · S/N NAV-4-2537 N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322 N2538THeeren Craig J · Williston, TNBuilt 1970 · S/N NAV-4-2538 N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078 N2539TSouthwest Aircraft LLC · Fairacres, NMBuilt 1970 · S/N NAV-4-2539

Back to AD 86-13-04 R3