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.

N241PKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 0102 N241RSalamon Uri · Boerne, TXBuilt 1980 · S/N CE-925 N241RDRegistration Pending · Missoula, MTRegistration pendingBuilt 1975 · S/N 18502934 N241RSHood Jeffery M · Ada, OKBuilt 2008 · S/N E-3879 N241SGFalasco Joseph R · Little Rock, ARBuilt 1999 · S/N 29-0196 N241SHSky West Aviation Inc Trustee · Albuquerque, NMS/N 0398 N241SLHickman Ira · West Richland, WABuilt 2005 · S/N 1283 N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110 N241WB1rk Ltd · Winston Salem, NCS/N TH-2246 N241WMWildman Air LLC · Mckinney, TXBuilt 1973 · S/N 18502253 N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N2428EHusel Robert · Bend, ORBuilt 2005 · S/N 1307 N2429EByrd David Phillip · King Salmon, AKBuilt 1966 · S/N 185-1172 N242FFThomas Leslie R · Kosse, TXBuilt 1971 · S/N D-9220 N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799 N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049 N242JBMcgregor Todd R · Cincinnati, OHBuilt 1966 · S/N CE-44 N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802 N242LManda Aviation LLC · Bakersfield, CABuilt 2016 · S/N L2K-219 N242MBRed Bird Aviation LLC · Waxhaw, NCBuilt 2004 · S/N 0911 N242MDSpyder Flights LLC · Manchester, PABuilt 2003 · S/N 29-0292 N242PZFennell Louis A Jr · Johns Island, SCS/N 40037 N242RLindley Charles D Jr · Spring, TXBuilt 1982 · S/N CE1001 N242RCCarrera Aviation LLC · Wilmington, DEBuilt 1972 · S/N TH-248 N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036 N242SFCurtin Christopher C · Ashburn, VABuilt 1977 · S/N D-10064 N242VPirshafiey Nasser Charles · Trabuco Canyon, CABuilt 1965 · S/N T210-0004 N2431YBennett Mark · Normangee, TXS/N 18503566 N2433TNw Aircraft Sales & Lesing LLC · Scappoose, ORS/N NAV-4-2433 N2435ACooper Timothy J · Spearman, TXBuilt 1969 · S/N D-9036 N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782 N243RZBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1983 · S/N 21064961 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2441TSelzer William J · Newaygo, MIBuilt 1962 · S/N NAV-4-2441 N2443TN2443t LLC · High Springs, FLBuilt 1962 · S/N NAV-4-2443 N2448AAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2015 · S/N TH-2448 N2449JSkydance Northwestern Inc · Minden, NVBuilt 1982 · S/N 18504364 N244DDTech Central LLC · Southport, NCBuilt 2014 · S/N E-4044 N244EBanyan Aircraft Sales LLC · Fort Lauderdale, FLBuilt 2008 · S/N TH-2226 N244GObrien Michael Timothy · Corpus Christi, TXBuilt 1999 · S/N 01 N244HEDubin David A · Tucson, AZS/N 21058990 N244JHDecca Aviation Operations Inc · Lincoln, NEBuilt 1976 · S/N E-818 N244JNShepherd Jacob · Lake Havasu City, AZBuilt 1964 · S/N D-7698 N244MBMunoz Santiago J · Kimberton, PABuilt 2005 · S/N 1426 N244SCGiacometto John · Stevensville, MTBuilt 2004 · S/N 42047 N244T727 Investments LLC · Lincoln, NEBuilt 2001 · S/N 0045 N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294 N24579Grunwaldt Peter J · Anchorage, AKBuilt 1982 · S/N 18504357

Back to AD 86-13-04 R3