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.

N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447 N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109 N401WCNakochna River Resort LLC · Willow, AKS/N 18502235 N401WMMrd Aero LLC · Manheim, PABuilt 1972 · S/N 401B0219 N401WWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1968 · S/N 401-0275 N4022YKelley Kitty K · Albion, IDBuilt 1961 · S/N 185-0222 N4023BSachs Robert W · Green Cove Springs, FLBuilt 1974 · S/N 75-30763 N4025BPalmer James F · Walla Walla, WABuilt 1975 · S/N 75-30743 N402AJ2lyons Enterprises LLC · Wellington, FLBuilt 1975 · S/N 402B0884 N402BFSnell Marion Lea · Ackerly, TXBuilt 1975 · S/N 402B1010 N402BKN402bk LLC · Nantucket, MABuilt 1978 · S/N 402C0689 N402CENorth American Aerial Surveys LLC · Tucson, AZBuilt 1973 · S/N 402B0364 N402CZEmission-Air Inc · Welcome, NCBuilt 1972 · S/N 402B0213 N402DZSamadi Jamshid · Leesburg, VAS/N 4020214 N402EASneed Leasing LLC · Nashville, TNBuilt 2001 · S/N E-3402 N402HGHyannis Air Service Inc DBA · Hyannis, MABuilt 1985 · S/N 402C1016 N402JHAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0500 N402NKKhan Pervez · Miami Springs, FLBuilt 1972 · S/N 402B0314 N402PWalker Mickey R · Sun City, AZBuilt 1992 · S/N CE-1671 N402PAAir Flight Inc · Fort Lauderdale, FLBuilt 1973 · S/N 402B0329 N402RSTropical Transport Services Ltd · San Jaun, PRBuilt 1980 · S/N 402C0402 N402SAAlly Mohamed Yacoob · Fort Lauderdale, FLS/N 402C0623 N402SBGlemone Airways Inc · Wilmington, DEBuilt 1979 · S/N 402C0082 N402SSKellair Ltd Inc · Sunrise, FLNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 402B0562 N402VNHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0488 N402WWPark Avenue Group Inc · Stuart, FLS/N 402B1061 N402ZKAirplane One LLC · Miami Springs, FLBuilt 1981 · S/N 402C0028 N4032CKrs Aerial Inc · Galloway, OHS/N 310R1351 N4034BRegistration Pending · Sheridan, WYRegistration pending, pending cancellationBuilt 1975 · S/N 75-30790 N4038BHarris James Thomas · Churubusco, INBuilt 1976 · S/N 76-30822 N4039BParish Aviation LLC · Earth, TXS/N 75-30733 N403AJAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1972 · S/N 402B0305 N403CDSma Air LLC · Lindstrom, MNBuilt 2005 · S/N 1406 N403CTCat Aviation LLC · Big Sky, MTBuilt 2004 · S/N 0973 N403DM403dm LLC · Indianapolis, INBuilt 1975 · S/N 310R0146 N403LDUngerecht Lyle · Independence, ORBuilt 2005 · S/N LIV-445 N403RMUlpiano Amy L · Carolina, PRS/N 402B0836 N403SWheeler James · Shreveport, LABuilt 1980 · S/N P21000403 N403SACalk Mark C · Troy, ALBuilt 2001 · S/N E-3407 N4042ARogden Aviation Inc · San Rafael, CABuilt 1970 · S/N D-9102 N4043AByard Jeffrey G · Carson City, NVBuilt 1970 · S/N D-9103 N4043GGalaxy Aviation Services LLC · Orlando, FLBuilt 1977 · S/N 340A0266 N4045AWdw Aviation Leasing Inc · Knoxville, TNBuilt 1970 · S/N D-9104 N4046BWildeson Dwight L · Troutdale, ORS/N 75-30788 N404BNCienski Todd A · Duncanville, TXBuilt 1965 · S/N 21058705 N404CPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 404-0238 N404CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 404-0065 N404CYWilkinson Aviation LLC · Wilmington, DEBuilt 2014 · S/N E-4040 N404DGSubgup LLC · Naples, FLS/N 414A0111 N404LFHicks Michael P Jr · Wallis, TXBuilt 1974 · S/N E-588

Back to AD 86-13-04 R3