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.

N4991FChouinard Christopher P · Friday Harbor, WABuilt 1966 · S/N U206-0691 N4991GAlderman Melvin R · Jacksonville, FLBuilt 1972 · S/N U20601823 N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146 N4991REast Side Mosquito Abatement District · Modesto, CABuilt 1975 · S/N 18802479T N4994FClark William R · Anchorage, AKBuilt 1967 · S/N U206-0694 N4994KMenefee Jerry V · Carson City, NVBuilt 1979 · S/N P21000392 N4994RCountry Air Service Inc · Hecla, SDS/N 18802481T N4998USixty Five Two Ten LLC · Oak Island, NCBuilt 1965 · S/N 21058698 N4999TAndy Aviation Inc · Live Oak, FLBuilt 1975 · S/N 18502729 N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006 N499DLCjrr Consulting LLC · Denver, COS/N EA-58 N499MBCook Joshua D - Trustee · Nashville, TNBuilt 1964 · S/N D-7587 N499RARenegade6 Aviation LLC · Woodbridge, VABuilt 2008 · S/N 411042 N499WWLakes Air LLC · Fargo, NDBuilt 1966 · S/N 411-0161 N49AJLvml Real Estate Investments LLC · Rio Grande City, TXBuilt 1978 · S/N P21000059 N49ARMoore Thomas A · Kennewick, WAS/N 421B0563 N49DCenturian 94n LLC · Ripon, CABuilt 1974 · S/N TH-542 N49ELPitts Flight Certification LLC · Nipomo, CABuilt 2024 · S/N E-4158 N49GCFinnegan Kevin · Indialantic, FLBuilt 1968 · S/N TE-585 N49HRBon-36 Ltd · Shavano Park, TXBuilt 1993 · S/N E-2790 N49JGCavanaugh James Martin Jr · Ann Arbor, MIBuilt 1990 · S/N CE-1505 N49JLPalmetto Aviation Solutions LLC · Woodruff, SCBuilt 1975 · S/N E-746 N49LFHerrera Gilbert Jr Trustee · Arcadia, CABuilt 1979 · S/N E-1510 N49MDHayes Jack D · Kingman, AZBuilt 1966 · S/N TE-57 N49PGVasiloff Mark · Barberton, OHBuilt 1967 · S/N D-8452 N49PSZulu Time LLC · Norfork, ARBuilt 1978 · S/N E-1227 N49SBGarcia Edward · Ooltewah, TNBuilt 1991 · S/N E-2661 N49STHedeen Arnold R · Seattle, WAS/N 21064844 N4AAAsi Jet Ag LLC · Hutchinson, MNBuilt 1977 · S/N 18503393 N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467 N4AFN4af LLC · Conroe, TXBuilt 1968 · S/N 421-0142 N4AHHand Kevin D · Anchorage, AKBuilt 1982 · S/N U20606655 N4ARN4ar LLC · Marienthal, KSBuilt 1979 · S/N P21000273 N4CGAffordable Avionics Ind DBA · Chino, CABuilt 1965 · S/N T210-0033 N4DXHuffman Aviation & Equipment LLC · Marietta, GABuilt 1972 · S/N 210-59600 N4EQUsi Leasing LLC · Garden City, KSBuilt 1984 · S/N E-2205 N4FAOgburn Benjamin R · Fernandina Beach, FLBuilt 1976 · S/N 310R0700 N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973 N4GAAircraft Owners And Pilots Association · Frederick, MDBuilt 1989 · S/N E-2466 N4GEEl Anclote LLC · Austin, TXBuilt 2010 · S/N E-3928 N4GKDalessandro Janet E · Park Falls, WIBuilt 1975 · S/N 310R0219 N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283 N4HESouth Florida Aerobatics LLC · West Palm Beach, FLBuilt 1976 · S/N TH-787 N4HFBat Plane LLC · Memphis, TNS/N E-2421 N4HHAndrews Terry · Camp Verde, AZS/N D-8422 N4JADiamond Aviation LLC · Tuscaloosa, ALBuilt 1994 · S/N TH-1714 N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642 N4KLRanspot Richard · Burlington, TXBuilt 1973 · S/N 18801394 N4LCCorbett Perry Howard III · Ferriday, LABuilt 1991 · S/N E-2617 N4LFMacys Flying Service Inc · Tulelake, CABuilt 1977 · S/N U20603705

Back to AD 86-13-04 R3