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.

N8184MAndrey Granin · Wantagh, NYBuilt 1964 · S/N 310I0184 N8184QJohn Richard A · Southwest Ranches, FLBuilt 1972 · S/N 310Q0636 N8191MWalters Larry C · Wasilla, AKBuilt 1964 · S/N 310I0191 N8195MPeed Robert M · Gilbert, AZBuilt 1964 · S/N 310I0195 N81ADMr Dent Inc · Manheim, PAS/N 401A0023 N81NNNona Tech LLC · Orlando, FLBuilt 1964 · S/N 320C0025 N81RTN81rt LLC · Middlebury, CTBuilt 1973 · S/N 310Q0742 N8242MGumar Sherko · Scottsdale, AZBuilt 1960 · S/N 39101 N8242QBirds Eye View Inc · Farmington, NMBuilt 1973 · S/N 310Q0715 N825GSRed River Ranch LLC · Wilmington, DEBuilt 1972 · S/N 310Q0510 N829EDiaz Maria · Kansas City, MOS/N 401A0014 N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156 N830LMarlow Aviation LLC · Lamoni, IAS/N 35514 N831CPConstant Pleasure LLC · Paso Robles, CAS/N 310Q0813 N8422FTownsend David · Piedmont, SCS/N 402-0270 N845YCFruscella Alfredo J · Tampa, FLBuilt 1973 · S/N 421B0351 N849JBDodson International Parts Inc · Rantoul, KSS/N 421A0075 N84RTChannell Robert D · Moreland, GABuilt 1973 · S/N 421B0355 N850KFInternational Air Services Inc Trustee · Carson City, NVS/N 310Q-0041 N85BGIsley Aviation Inc · Fort Myers, FLBuilt 1974 · S/N 310Q1068 N85MJZundel Dana John · Watkins, COS/N 35772 N85SRMccorkle Air LLC · Wilmington, DEBuilt 1974 · S/N 310Q0903 N860RCCornell Christopher M · Corpus Christi, TXS/N 421B0035 N863CPNet Quest Management Services LLC · Winter Haven, FLBuilt 1968 · S/N 421-0117 N86HHigh Country Aviation LLC · Helena, MTBuilt 1960 · S/N 39087 N871Registration Pending · Las Vegas, NVRegistration pendingBuilt 1958 · S/N 35700 N878SPC-140 Co LLC · Milton, FLBuilt 1974 · S/N 421B0634 N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883 N87MKWind River Aviation LLC · Lawton, OKBuilt 1974 · S/N 421B0808 N881RMMadden Robert B · Eagleville, PABuilt 1966 · S/N 310K0114 N882GLProctor Brian S · Leesburg, TXBuilt 1963 · S/N 320B0026 N888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeBuilt 1973 · S/N 421B-0421 N888HCGolden Eagle 888hc LLC · Durham, CABuilt 1975 · S/N 421B0821 N888RCLeahy Kyle Bergen · Dallas, TXS/N 310I0067 N888TZollman Garry L · Pendleton, ORBuilt 1959 · S/N 35925 N888VVAbaco Xpress LLC · West Palm Beach, FLBuilt 1973 · S/N 421B0550 N88JBJr Aviation LLC · Benton, KSBuilt 1969 · S/N 310P0174 N88LTRyan M Kearbey Dental Corp · Oroville, CABuilt 1973 · S/N 310Q0835 N88RNInternational Air Services Inc Trustee · Carson City, NVS/N 310J-0077 N88XCollins Ken W · Olympia, WAS/N 35075 N8904ZBuess Wayne R · Shirley, NYBuilt 1961 · S/N 310G0004 N8906ZGrismer Jeff Trustee · Hemet, CABuilt 1961 · S/N 310G0006 N8908ZLevin Robert G · Roseburg, ORBuilt 1961 · S/N 310G0008 N8909ZSumthin Limited · Wilmington, DEBuilt 1961 · S/N 310G-0009 N890GRFly Compton Aeronautical Education Foundation · Compton, CAS/N 310H0130 N8910ZRazorhawk LLC · Birmingham, ALBuilt 1961 · S/N 310G0010 N8911ZSt Francis Aircraft LLC · Montrose, COBuilt 1961 · S/N 310G0011 N8923ZPanting Edwin A · Anchorage, AKBuilt 1962 · S/N 310G-0023 N8927ZEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1962 · S/N 310G-0027 N8928ZSwanson Garret C · Valentine, NEBuilt 1962 · S/N 310G0028

Back to AD 72-14-08 R1