Registered aircraft · 18,498

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.

N155LCAle & Quail Club LLC · Cheyenne, WYBuilt 1968 · S/N TE-615 N155RCClark 155 LLC · Missoula, MTS/N 21064312 N155WCTca Equities LLC · Advance, NCBuilt 1981 · S/N TE-1193 N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368 N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097 N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717 N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993 N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854 N1561LRegistered aircraftBuilt 1994 · S/N E-2856 N1561MWagner Lacy F · Mission Viejo, CABuilt 1989 · S/N CE-1374 N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777 N1562BKaplan Steven H Trustee · Santa Barbara, CABuilt 1989 · S/N CE-1362 N1562FPatton Janet · Denton, TXBuilt 1994 · S/N E-2857 N1563BShulman David A · Frisco, TXBuilt 1994 · S/N CE-1776 N1563EZulu Alpha LLC · Naperville, ILBuilt 1989 · S/N E-2473 N1563FMcintyre Philip · Monterey, CABuilt 1994 · S/N CE-1782 N1563RNovember One LLC · Trophy Club, TXS/N E-2858 N1563TN1563t LLC · Sheridan, WYS/N 414-0278 N1563WArmstrong James L Trustee · Santa Barbara, CABuilt 1972 · S/N D-9370 N1564AMcnutt Seth D · Paoli, INBuilt 1989 · S/N CE-1321 N1564DAwy LLC · Bentonville, ARBuilt 1994 · S/N E2905 N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6 N1564RKm Unlimited LLC · Fallbrook, CABuilt 1988 · S/N EA-487 N1565TForbes Consolidated Inc · New Smyrna Beach, FLBuilt 1974 · S/N 310R0063 N1565WRoad Kill Aviation Inc · Wilmington, DEBuilt 1972 · S/N E-330 N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853 N1566GDuntz David W · Beavercreek, OHBuilt 1989 · S/N CE-1346 N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549 N1566LRedden Timothy Ray · Citrus Heights, CABuilt 1976 · S/N D-9862 N1566PBeech Powers LLC · Henderson, NVBuilt 1988 · S/N CE-1294 N1566URegistered aircraftBuilt 1994 · S/N E-2872 N1566WPsl Aviation Inc · Atlanta, GABuilt 1994 · S/N TH-1713 N1567MPlumbo John T · Port Saint Lucie, FLBuilt 1989 · S/N CE-1407 N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567 N1567PMy Family Holdings LLC · Greenwood, SCBuilt 1988 · S/N CE-1296 N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542 N1569PFlying Bull Aviation LLC · Santee, CABuilt 1988 · S/N CE-1300 N1569USchoolcraft Carl L · West Harrison, INBuilt 1973 · S/N U20602262 N156ASkymook Aviation LLC · Beaver Falls, PABuilt 1977 · S/N TK-56 N156JBSully Air LLC · Atlanta, GABuilt 2001 · S/N 40019 N156KCWhitney Aviation LLC · Derry, NHBuilt 1978 · S/N 18503621 N1570CMottern Edward Thomas · Greenwood, SCBuilt 2003 · S/N 0569 N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512 N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715 N1570TAcr Holdings LLC · Marysville, OHBuilt 1989 · S/N CE-1365 N1570UReno70 LLC · Anchorage, AKBuilt 1970 · S/N 20700170 N1571UFavero Michael R · Sacramento, CABuilt 1973 · S/N U20602263 N1571WWest Elk Construction Ltd · Milliken, COBuilt 1972 · S/N D-9349 N1574PSouthern Seaplane Inc · Belle Chasse, LABuilt 1976 · S/N 21061258 N1576HBloom Timothy S · Chugiak, AKBuilt 1977 · S/N 18503309

Back to AD 86-13-04 R3