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.

N6234ZBruce Bullock · West End, NCBuilt 1981 · S/N E-1985 N6236VIngraham Randy · Colbert, WABuilt 1968 · S/N E-1 N62379Sullivans Island Aerospace LLC · Sullivans Island, SCBuilt 1982 · S/N E-2007 N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303 N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393 N6238VTurner James D · Duvall, WABuilt 1967 · S/N D-8588 N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304 N623AMMelgar Albert T · El Paso, TXBuilt 1979 · S/N 79-30928 N623CDVitalis Maynard · Medford, ORBuilt 2005 · S/N 1259 N623MHBearden George F Jr · Weatherford, TXBuilt 1989 · S/N CE-1364 N623VSJones Lloyd Val · Blanding, UTBuilt 2005 · S/N 1708 N623WMMclaughlin Mike I · Portola Valley, CABuilt 2002 · S/N 0208 N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718 N6240VRegistered aircraftBuilt 1967 · S/N D-8628 N6240XCoal Black Cattle Co LLC · Roundup, MTBuilt 1977 · S/N 340A0437 N6243CDcd Aircraft Sales LLC · Leesburg, FLS/N 21063841 N6243VManning William O Trustee · High Point, NCBuilt 1967 · S/N D-8585 N6243ZSeattle Seaplanes LLC · Seattle, WABuilt 1981 · S/N U20606199 N6246BR L Equipment And Services LLC · Monument, COBuilt 1978 · S/N 21062721 N6247VNichols Mark W · St Pete Beach, FLBuilt 1967 · S/N D-8614 N6249QKnudsen Russell G · East Troy, WIBuilt 1969 · S/N 401A0049 N624BCBaugh Jeff G · Brigham City, UTS/N 337-1025 N624CAdventum LLC · Saco, MEBuilt 2008 · S/N E-3834 N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876 N624CDProvincial Properties LLC · Johnson City, TNS/N 1119 N624CMJma Aviation LLC · Cincinnati, OHS/N 1249 N624DKFw Cielo LLC · Canton, OHBuilt 1976 · S/N D-9879 N624DRRyan Air Inc · Anchorage, AKBuilt 1979 · S/N 20700517 N624ERRyan Air Inc · Anchorage, AKBuilt 1982 · S/N 20700752 N624LDMicrofoundations Inc · Truckee, CABuilt 2022 · S/N ES-099 N624MTJcct Holdings LLC · Plano, TXBuilt 1978 · S/N 210-62913 N624NPHackett Stevan S · Jacksonville, ILBuilt 1969 · S/N D-9010 N624PKBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B0144 N624TELenbob Aviation LLC · Southaven, MSS/N TH-1588 N6254NCoil Construction Inc · Columbia, MOBuilt 1981 · S/N E-1989 N6255BRogers Aeronautics LLC · Lake Barrington, ILBuilt 1981 · S/N E-1990 N6255HRenfro Michael W · Bethel, AKS/N 20700452 N6255JAzimuth Aviation LLC · Mechanicsburg, PABuilt 1996 · S/N E-3019 N6255QValiair Limited Company Trustee · Casper, WYBuilt 1969 · S/N 401A0055 N6258NTango Victor Aviation LLC · Kingsburg, CABuilt 1978 · S/N 340A0449 N625CBPowers Brothers Real Estate · Henderson, TXBuilt 2005 · S/N 1391 N625CDTurner David C · Clinton Township, MIBuilt 2005 · S/N 1636 N625HWBsw Acceptance Inc · Muleshoe, TXBuilt 1993 · S/N TH-1694 N625JLTurbulent Returns LLC · Minneapolis, MNBuilt 1980 · S/N 414A0508 N625KWSchmoker William C · Eden Prairie, MNBuilt 1974 · S/N U20602635 N625LMDsb Investments LLC · Dodge City, KSBuilt 1991 · S/N CE-1600 N625MOverbeek Michael F · Holland, MIBuilt 1974 · S/N TH-434 N625RLPerry James Edward · Cleveland, GABuilt 1979 · S/N 79-30960 N625SGoldman Ryan · Cordova, TNBuilt 1972 · S/N TE-881 N625TBGeneral Aerospace Co LLC · Great Falls, VABuilt 2001 · S/N 30-0061

Back to AD 86-13-04 R3