Registered aircraft · 18,495

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.

N9470QCullison James B Trustee · Canby, ORBuilt 1972 · S/N D-9327 N9471NBas Part Sales LLC · Greeley, COBuilt 1981 · S/N 18504362 N9472MValentine Kurt J · Apple Valley, MNBuilt 1970 · S/N 21059372 N9472NHuang Sophie M · Newcastle, WABuilt 1981 · S/N 18504363 N9473MOpie Milton J III · White Lake, MIBuilt 1970 · S/N 21059373 N9473QStephens Milton D · Birmingham, ALBuilt 1972 · S/N E-315 N9475MRyan Air Inc · Anchorage, AKBuilt 1981 · S/N 20700695 N9475RVon Imhof Rudi F · Anchorage, AKBuilt 1985 · S/N U20606872 N9475SKovalenko Andrew R · Mill Creek, WABuilt 1966 · S/N CE-3 N9476CZulu Echo Assets LLC · Port Washington, NYBuilt 1982 · S/N T30300179 N9476SPatti Brian · Prescott, AZBuilt 1966 · S/N CE-4 N9478SRocket Pjr LLC · Helena, MTBuilt 1966 · S/N D-8057 N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679 N9479SEckert Paul D · Carlsbad, CABuilt 1966 · S/N CE-5 N947CDDavis Brian T · Prescott, AZS/N 1725 N947ETGranite State Aerial Topography LLC · Wolfeboro, NHBuilt 1973 · S/N U20602271 N947TTobler Patrick M · Wake Forest, NCBuilt 1971 · S/N D-9270 N9480QCrockett Richard S · St George, UTBuilt 1972 · S/N CE-370 N9480SDucker James G Jr · Laurel, MSBuilt 1966 · S/N CE-6 N9481QSterengin Pllc · Cottonwood, AZS/N CE-371 N9481SPronko David D · Louisville, KYBuilt 1966 · S/N CE-7 N9482MWestwind Aviation Inc · Phoenix, AZBuilt 1981 · S/N 20700698 N9482QSoberg Bryant W · Hartford, SDS/N E-318 N9482RWindy Lane Farms Transport LLC · Mulberry, INBuilt 1975 · S/N 18802292T N9483QSouthwest Investment Co · Little Rock, ARS/N D-9331 N9483SAdvanced Flight Systems Inc · Canby, ORBuilt 1966 · S/N CE-16 N9483YSioux Falls Technology LLC · Sioux Falls, SDBuilt 1981 · S/N 21064520 N9485RStevenson Flying Service LLC · Selden, KSBuilt 1975 · S/N 18802294T N9486GAndrew Odean T · Willow, AKBuilt 1971 · S/N U20601686 N9486RAnderson Aerial Spraying Serv Inc · Canby, MNBuilt 1975 · S/N 18802295T N9487QLebarron David · Winnsboro, TXBuilt 1972 · S/N D-9333 N9487SBailey Hugh E · Gainesville, VABuilt 1966 · S/N D-8067 N9488CGalloway Christopher · Davis, CABuilt 1982 · S/N T30300180 N9488EV2 Destinations LLC · Cullman, ALBuilt 2000 · S/N E-3367 N9489SRoccatani Dante D · Merritt Island, FLBuilt 1966 · S/N TE-79 N9489ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1981 · S/N U20606525 N948CDSouth Delta Aviation Inc · West Helena, ARBuilt 2004 · S/N 1065 N948HCHarrison Contracting Company Inc · Villa Rica, GAS/N 0712 N9490YKearins John M · North Hampton, NHBuilt 1969 · S/N 20700110 N9491QMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1972 · S/N E-321 N9492SBlue Line Aerial Productions LLC · Lexington, KYBuilt 1966 · S/N D-8065 N9493SQuigley Timothy P · Eagleville, TNBuilt 1966 · S/N CE-8 N9493ZCcf Ventures Inc · Bangor, MEBuilt 1981 · S/N U20606527 N9494NMaine Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1981 · S/N 18504365 N9495SLsa LLC · Kalispell, MTBuilt 1966 · S/N D-8068 N9496HKoropp Michael L · Anchorage, AKBuilt 1977 · S/N 18503442 N9496MRegistered aircraftBuilt 1970 · S/N 21059396 N9497MJomama Aviation LLC · Kalispell, MTBuilt 1970 · S/N 21059397 N9498GSak III LLC · Miller, SDS/N 18801503T N9498MVoorhies Jon · Atascadero, CABuilt 1970 · S/N 21059398

Back to AD 86-13-04 R3