Registered aircraft · 2,552

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:76-08-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2') 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:76-08-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
  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:76-08-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-08-02-R2')
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.

N2920RCarboneau Luke · Las Cruces, NMBuilt 1962 · S/N 310G0120 N2928RRonin Aero Group LLC · Coconut Creek, FLBuilt 1962 · S/N 310G0128 N2946RCendejas Agustin · Chino, CAS/N 310G0146 N2951RRickert Richard A · Thornton, COBuilt 1962 · S/N 310G0151 N2957QGenerals International Inc · Red Oak, TXBuilt 1969 · S/N 421A0057 N2971QOn The Beam Aviation Inc · Hampton, GABuilt 1974 · S/N 310Q1074 N2979SAerospace Trust Management LLC Trustee · Wilmington, DES/N 4110272 N299AOverman Robert W · Fairfield, OHBuilt 1964 · S/N 320B-0057 N299BFMacvey Troy R · Milan, INBuilt 1967 · S/N 310L-0093 N29BEAltaii Ali · Gibraltar, MIBuilt 1971 · S/N 340-0005 N2JJAerial Surveys International LLC · Watkins, COBuilt 1968 · S/N 401-0235 N2MBAlfa Foxtrot LLC · Statesville, NCBuilt 1978 · S/N 310R1357 N2UMHepfer John Edward · Midland, TXBuilt 1958 · S/N 35649 N2WTJohnson Michael A · Winter Park, COS/N 38117 N2XXTyler James · Oklahoma City, OKS/N 310L0182 N2YEAllied Moulded Products Inc · Bryan, OHBuilt 1975 · S/N 310R0577 N3003DRoach James M · West Bountiful, UTBuilt 1955 · S/N 35203 N3003L310-J Enterprises Inc · Parkland, FLBuilt 1965 · S/N 310J0003 N3006DWarmkesserl James R · Felton, CABuilt 1955 · S/N 35206 N3008RPerguson Robert C · Converse, TXBuilt 1962 · S/N 320A0008 N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258 N300EB4031 Pilots LLC · Crown Point, INBuilt 1974 · S/N 310R0082 N300EJPartwin LLC · Greenwich, CTBuilt 1974 · S/N 310Q1156 N300FDGondola Investments LLC · Miami, FLS/N 402B1359 N300MBIglesia De Cristo · Porter Ranch, CABuilt 1974 · S/N 421B0573 N300PM300pm LLC · Bloomington, INBuilt 1978 · S/N 310R1382 N3010LJones Johnny R · Thermopolis, WYBuilt 1965 · S/N 310J0010 N3011TBranson West Development Inc · Paso Robles, CABuilt 1964 · S/N 320C0011 N3012TCain James W · Big Rapids, MIBuilt 1964 · S/N 320C0012 N301DBDon Davis Aviation Inc · Henderson, KYBuilt 1977 · S/N 310R0891 N3020DAllen Gregory L · Lake View, ALBuilt 1955 · S/N 35220 N3020RHill James C · Grand Saline, TXBuilt 1962 · S/N 320A0020 N3021TGolden Arrow Transportation · Plainfield, NJBuilt 1964 · S/N 320C0021 N3023LBirge Chad W · Alcoa, TNBuilt 1965 · S/N 310J0023 N3025DBanducci Debra L Trustee · Bakersfield, CABuilt 1955 · S/N 35225 N3026TBox William C · Goldsby, OKS/N 320C0026 N3027RLedford James · Broad Run, VABuilt 1962 · S/N 320A0027 N3027TPlane Services LLC · Twin Falls, IDBuilt 1964 · S/N 320C0027 N3029TConsolidated Resource Imaging LLC · Grand Rapids, MIBuilt 1964 · S/N 320C-0029 N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909 N302SKHaynes Daniel R · New Braunfels, TXBuilt 1965 · S/N 310J-0036 N3031LCavender Kelly P · Prosper, TXBuilt 1965 · S/N 310J0031 N3031RSearch Gordon · Joliet, ILBuilt 1960 · S/N 39115 N3034LTown Thomas L · Chino Valley, AZBuilt 1965 · S/N 310J0034 N3034TVelez Investments LLC · Orlando, FLS/N 320C0034 N3039TDdc Investments LLC · Hot Springs, ARBuilt 1964 · S/N 320C0039 N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303 N3040LLuft Inc · North Fort Myers, FLS/N 310J0040 N3040RSturgeon Newton Charles · Midland, TXBuilt 1963 · S/N 320A-0040 N3041TSouthern Oregon Skyways Inc · Medford, ORBuilt 1964 · S/N 320C0041

Back to AD 76-08-02 R2