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.

N545GMInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N D-9318 N545LKKernisan Louis Philippe · Doral, FLBuilt 2000 · S/N E-3348 N545WKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 21060656 N5460UMall Eugene R · Cairo, NYBuilt 1967 · S/N CE-173 N5461Lb Flying Aces LLC · Wilmington, DEBuilt 1991 · S/N E-2621 N5461JGlyn Dwr Aviation LLC · Kalispell, MTS/N 310R0259 N5461XState Of Alaska · Anchorage, AKBuilt 1980 · S/N U20605775 N5462XThomas Jackson Smitih · Baton Rouge, LABuilt 1977 · S/N E-1105 N5463JMachado Joe L · Tucson, AZBuilt 1980 · S/N 17273804 N5464VLivingood Richard A · Tucson, AZS/N 21060955 N5467APiedmont Air Services LLC · Helena, MTBuilt 1979 · S/N 21063454 N5468ELehr Robert J · Pleasant Dale, NEBuilt 1979 · S/N 18503979 N5469VSchweers John · Plano, TXBuilt 1967 · S/N D-8565 N5469XTechaero 210 LLC · Healdsburg, CABuilt 1980 · S/N P21000507 N546CDScalini Fernando A · Huntington Beach, CABuilt 2005 · S/N 1627 N546ESBurgess James R · Cave Creek, AZBuilt 2014 · S/N MEW001ES N5471GGlenn William · Hilton Head Island, SCBuilt 1978 · S/N E-1338 N5474JRedick Albert L II · Reno, NVBuilt 1975 · S/N 310R0272 N5476YAltura Aviation 2 LLC · Charlotte, NCBuilt 1980 · S/N 21064219 N5479JBluegoose Aviation LLC · Muscle Shoals, ALBuilt 1975 · S/N 310R0277 N547CHoch Jeffrey · Seattle, WABuilt 2003 · S/N 0484 N547EMWolcott John · Peoria, AZBuilt 1979 · S/N P21000271 N5482CSantiago Robert S · Torrance, CABuilt 1979 · S/N 21063764 N5484JCaba Joseph · Covington, LAS/N 310R0282 N5485EColorado Parks And Wildlife · Grand Junction, COBuilt 1979 · S/N 18503981 N5487USuss Charles H Trustee · Woodford, VTBuilt 1967 · S/N D-8559 N5488JGrace Aviation LLC · Rogers, ARBuilt 1975 · S/N 310R0286 N548EBRomeo Charlie Aircraft Partners LLC · North Little Rock, ARS/N 0291 N548GAHyannis Air Service Inc · Hyannis, MABuilt 1982 · S/N 402C0653 N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467 N5490JCullen Clay T · Danbury, CTS/N 310R0288 N5491UAarestad Potato Co Ltd · Halstad, MNBuilt 1967 · S/N D-8584 N5494EBloom William K · Wrangell, AKBuilt 1979 · S/N 18503983 N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470 N5495JMesquite Express LLC · Waco, TXBuilt 1975 · S/N 310R0293 N5495VPhillips Ruffin P Jr · Lexington, NCBuilt 1975 · S/N 21060964 N5499UDavis Bret K · Boynton Beach, FLBuilt 1967 · S/N CE-160 N549CDValiair Limited Co Trustee · Casper, WYBuilt 2004 · S/N 1088 N549PTGrant P T · Musella, GABuilt 1976 · S/N TH-711 N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54CCScythe & Spade Co · Grand View, IDBuilt 1979 · S/N P21000360 N54DFSkywave Associates LLC · Spirit Lake, IABuilt 1972 · S/N 340-0172 N54DGSaffron Aviation LLC · Carrollton, GABuilt 1979 · S/N E-1562 N54DZMcdonald Donald F · Greer, SCBuilt 1983 · S/N 21064820 N54EJHigh Plains Aviation LLC · Caro, MIS/N 18504330 N54GVAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1978 · S/N 20700447 N54HLOverbey Michael B · Houston, TXBuilt 1972 · S/N CE-376 N54JNDlz Aviation LLC · Ostrander, OHBuilt 1991 · S/N E-2684 N54JQRegistered aircraftN-number assigned (import), not yet registeredS/N 414A0086 N54KDSawtooth Flying Service Inc · Mccall, IDBuilt 1981 · S/N U20606181

Back to AD 86-13-04 R3