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.

N603ETSanborn Map Co · Colorado Springs, COBuilt 1973 · S/N U20602230 N603JHAirdent LLC · Trinity, FLBuilt 1978 · S/N E-1271 N603STThunder Creek LLC · Strafford, NHBuilt 2014 · S/N TH-2412 N60402Bajaj Rajesh · Florence, SCBuilt 1979 · S/N E-1498 N6040FJct Holdings LLC · Henderson, NVS/N D-7814 N6040RSixtyforty LLC · Mequon, WIBuilt 1979 · S/N TH-1026 N6041FKabo LLC · Las Vegas, NVBuilt 1965 · S/N D-7816 N6043G4031 Aviation Inc · Bemidji, MNBuilt 2003 · S/N 0607 N6044NB407 LLC · Seattle, WABuilt 1981 · S/N 18504298 N6044SPinewood Properties LLC · Hayward, WIBuilt 1976 · S/N TJ-42 N60454Valiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1373 N6046NPappas Joshua · Wilmette, ILBuilt 1981 · S/N 18504300 N6047SNeihouser Brad · Francesville, INBuilt 1976 · S/N TJ-37 N6048GWitthuhn Johnie B · Callaway, NEBuilt 1973 · S/N 18801172T N6048NAero-Mach Labs Inc · Wichita, KSBuilt 1978 · S/N 21062916 N6049FBrown Boot Aviation LLC · Chesapeake, VABuilt 1965 · S/N D-7820 N604HBDownhour Aviation LLC · Benton, LABuilt 2004 · S/N 1223 N604WMPrivate Aviators LLC · Loretto, MNBuilt 2005 · S/N 1260 N6050MAgl Aviation And Management LLC · Payson, AZBuilt 1979 · S/N E-1632 N6050SKittleson Allen F · Granbury, TXBuilt 2002 · S/N 1943 N6050TGullett Aviation LLC · Palatka, FLBuilt 1979 · S/N E-1488 N60519Bunn Robert Michael Trustee · Salina, KSBuilt 1980 · S/N E-1687 N6051CQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0600 N6051MEbe Inc · East Moline, ILBuilt 1979 · S/N E-1492 N60526Sch Aviation Inc Owner Trustee · Sporle Kings LynnS/N TE-1159 N60527Smith Sidney R Trustee · Rllng Hls Est, CABuilt 1979 · S/N D-10235 N60529My Holdings Inc · Anchorage, AKBuilt 1973 · S/N U20602030 N6052SCrosswinds Flight Center Inc · Drums, PABuilt 1979 · S/N CE-855 N6053UAtlas Vineyard Management Inc · Napa, CABuilt 2003 · S/N 0621 N6054DBrookshier Delbert L · Comanche, TXBuilt 1979 · S/N CE-856 N6054M6054m LLC · Morrison, ILBuilt 1979 · S/N E-1500 N6055JElkhorn Valley Aviation LLC · Fremont, NEBuilt 1979 · S/N TE-1160 N6056YDiesel Flying LLC · Wilmington, DEBuilt 1979 · S/N D-10242 N6057SRamelow Noyan · Seabrook, TXBuilt 1976 · S/N TJ-45 N6058AAlpha Air LLC · Sparks, NVBuilt 1979 · S/N TH-1017 N60597Ritchie James E · Grand Junction, COBuilt 1973 · S/N U20602036 N6059SGallardo Jorge Luis Marquez · El Mirage, AZS/N TJ-49 N605CDFl175 Aviation Partners LLC · Sugar Land, TXBuilt 2005 · S/N 1486 N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005 N605MHSteinberg Kenneth R · Longport, NJBuilt 2005 · S/N 1469 N605NRState Of Minnesota · Grand Rapids, MNBuilt 1985 · S/N 18504437 N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041 N60617Williams Robert M · Red Hook, NYBuilt 1974 · S/N 21060595 N60636Allard Michael L · Penrose, COS/N 21060596 N6064EBeauboeuf Jeffrey M · Woodworth, LABuilt 1959 · S/N D-5995 N6064SYasechko James Edward · Bonaire, GABuilt 1975 · S/N D-9819 N6065SEdwards Aviation LLC · Fresno, CABuilt 1975 · S/N CE-613 N6067SCanterbury Ventures LLC · Litchfield Park, AZBuilt 1975 · S/N CE-614 N6067TSullivan Patrick V · Chicago, ILBuilt 2002 · S/N E-3467 N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136

Back to AD 86-13-04 R3