Skip to content

Registered aircraft · 1,578

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

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 N2JJAerial Surveys International LLC · Watkins, COBuilt 1968 · S/N 401-0235 N2UMHepfer John Edward · Midland, TXBuilt 1958 · S/N 35649 N2WTJohnson Michael A · Winter Park, COS/N 38117 N2XXTyler James · Oklahoma City, OKS/N 310L0182 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 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 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 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 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 N3042LMsl Holdings · Newbury Park, CABuilt 1965 · S/N 310J0042 N3042TKls Enterprises Inc · Cave Creek, AZBuilt 1964 · S/N 320C0042 N3043TJwt Aviation LLC · Yancey, TXBuilt 1964 · S/N 320C0043 N3048LLuster Maurice A Jr · Miami Beach, FLS/N 310J0048 N304MCValiair Lc Trustee · Casper, WYS/N 421B0130 N3050LMadison Mitchell · Guthrie, OKBuilt 1965 · S/N 310J0050 N3050TLand T Chat · Tulsa, OKBuilt 1964 · S/N 320C0050 N3051TPacific Arts Collection LLC · Oakland, CAS/N 320C0051 N3055TTechnical Education Services · Virginia Beach, VABuilt 1965 · S/N 320C0055

Back to AD 72-14-08 R1