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.

N5222RLebeouf Bros Towing LLC · Bourg, LABuilt 1976 · S/N 18503021 N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316 N5224UNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1964 · S/N 206-0224 N5225VKuhn Chad · Boulder, WYBuilt 1975 · S/N 21060867 N5226UJohnson Stephen M · Westlake, TXBuilt 1964 · S/N 206-0226 N5227JSbs Partnership · Henderson, NVBuilt 1980 · S/N 340A1036 N5227RThomas Myles S · Fairbanks, AKBuilt 1976 · S/N 18503023 N5228KD/S Aviation LLC · Las Vegas, NVS/N NAV-4-2128B N5228VDynamite Marketing Inc · Meridian, IDBuilt 1975 · S/N 21060870 N522ARMedic Choppers LLC · Springdale, ARBuilt 2005 · S/N 1534 N522CDFbm LLC · La Porte, INBuilt 2002 · S/N 0193 N522DDHw Aviation LLC · Largo, FLBuilt 2005 · S/N 1322 N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399 N522KGJdi Electrical Solutions Inc · Temecula, CABuilt 2004 · S/N 1170 N522MGParker James V · Cashiers, NCFirst renewal noticeBuilt 2003 · S/N 0540 N522PUFlying Club LLC · New York, NYBuilt 2005 · S/N 1561 N522RBWahoo Aviation Inc · Charlotte, NCBuilt 2013 · S/N TH-2372 N522WMJaybirds Aviation LLC · Saint Cloud, MNBuilt 2003 · S/N 0670 N5230UAllen Etienne · Simi Valley, CABuilt 1964 · S/N 206-0230 N5232UScruggs Kenneth R · Galloway, OHBuilt 1964 · S/N 206-0232 N5233UKenai Gravel Products LLC · Salt Lake City, UTFirst renewal noticeBuilt 1964 · S/N 206-0233 N523AMSigma Aviation LLC · Vancouver, WABuilt 1981 · S/N E-1723 N523CHawk Unlimited LLC · Kalispell, MTBuilt 1998 · S/N E-3161 N523DBN523db LLC · Santa Ana, CABuilt 1999 · S/N EA-643 N523JTAircraft Partner Holdings Inc Trustee · BerlinBuilt 2005 · S/N 29-0380 N523PWbj Aviation LLC · Jackson, GAS/N E3853 N523QNixon John H · Ormond Beach, FLBuilt 1967 · S/N D-8582 N523RCS W Air Travel Inc · Parshall, COBuilt 1975 · S/N 21060654 N523SHNesher Wings LLC · Phoenix, AZBuilt 1998 · S/N EA-618 N523TCSmith Ranch Bonanza LLC · San Francisco, CABuilt 1964 · S/N D-7613 N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596 N5244URoberts Todd · Friday Harbor, WABuilt 1964 · S/N 206-0244 N5244ZRobinson Levi B · Anchorage, AKBuilt 1981 · S/N U20606085 N5245CN5245c LLC · Sequim, WABuilt 1978 · S/N 310R1523 N5245JNuzzo Christian Larsen · Locust Grove, GABuilt 1976 · S/N 310R0811 N5249ABrentco Aerial Patrol Inc · Canton, OHBuilt 1985 · S/N P21000840 N524BLDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 21058477 N524BSCarpenter Robert L · Alto, NMBuilt 2007 · S/N E-3815 N524CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0522 N524CBTechnical Film Systems Inc · Camarillo, CABuilt 1991 · S/N TH-1630 N524CDDriscoll Cindy M · Savannah, TNBuilt 1968 · S/N E-81 N524ESDickinson Drew H · New Braunfels, TXBuilt 2005 · S/N ES-182 N524HSBonanza N524hs LLC · Salem, ORBuilt 2007 · S/N E-3792 N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717 N524QBartel Christopher H DBA · Williamsburg, PABuilt 1967 · S/N TE-453 N524RTN524rt LLC · Greensboro, NCBuilt 1970 · S/N TH-123 N525Alpine Aviation LLC · Oklahoma City, OKBuilt 2007 · S/N TH-2188 N5251CSherman Randolph · Beverly Hills, CABuilt 1978 · S/N 310R1526 N5251JNarr Craig S · Fort Mohave, AZBuilt 1976 · S/N 310R0813 N5251UDavid Vanderpol Construction Co · Harrison, SDS/N 206-0251

Back to AD 86-13-04 R3