Skip to content

AD 2002-13-05 R1

Registered aircraft · 484

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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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.

N299DRKings County Sheriffs Office · Hanford, CABuilt 1986 · S/N 196E N305JEDah Aircraft LLC · Georgetown, SCBuilt 1982 · S/N 1194D N307APMg Holdings LLC · Alpine, WYBuilt 2020 · S/N 0323FF N311VTGeco Inc · Wilmington, DEBuilt 1987 · S/N 0229E N315SHJc Aircraft Leasing LLC · Wasilla, AKS/N 1120D N316HKHawkeye Holdings LLC · Lyndon, KSBuilt 1979 · S/N 390479D N31HMDah Aircraft LLC · Georgetown, SCBuilt 1977 · S/N 1160027D N321PERadnor Construction Of Delaware Inc · Allentown, PABuilt 1989 · S/N 0342E N331WHSchreindl Lawrence A · Colton, ORS/N 0207E N333TABallard Aviation Inc · Newton, KSBuilt 1979 · S/N 590500D N33TJRhk Of Kansas Inc · Overland Park, KSS/N 711016D N348Bhh Leasing #2 LLC · Pensacola, FLBuilt 1980 · S/N 1000824D N35002Md Helicopters LLC · Mesa, AZS/N 0360FF N35006Md Helicopters LLC · Mesa, AZS/N 0361FF N35011Md Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0350FF N35017Md Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0349FF N35019Usda Aphis Ws Atoc · Cedar City, UTBuilt 2024 · S/N 0348FF N3501DMd Helicopters LLC · Mesa, AZBuilt 2026 · S/N 0356FF N3501FMd Helicopters LLC · Mesa, AZS/N 0359FF N3501LMd Helicopters LLC · Mesa, AZS/N 0358FF N3501NMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0339FF N3501QMd Helicopters LLC · Mesa, AZS/N 0338FF N3501TMd Helicopters LLC · Mesa, AZS/N 0354FF N3501VMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0353FF N3501ZMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0351FF N3502AMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0347FF N3502PMccarty David M · Baker City, ORBuilt 2023 · S/N 0346FF N353AHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 811079D N357MHAa Leasing Lp · Kilauea, HIBuilt 1982 · S/N 1171D N35KHBlackbell 22 LLC · Wilmington, DEBuilt 2024 · S/N 0355FF N361SHLima Whiskey LLC · Missoula, MTBuilt 1989 · S/N 0058FF N362MNHeli Ag LLC · Plantersville, TXBuilt 1979 · S/N 390462D N363CCBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 1070208D N365PRAerotrust Services Corp Trustee · Wilmington, DES/N 1180365D N367PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0344FF N369DRatcliff Dustin · Saltville, VABuilt 1977 · S/N 1070209D N369EDMonroe Helicopters LLC · Vestavia, ALBuilt 1978 · S/N 870167D N369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861D N369FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1981 · S/N 610983D N369FFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 0709FF N369JHJack Harter Helicopters Inc · Lihue, HIBuilt 1985 · S/N 0145E N369JVAviation Advantage Inc · Tabor City, NCS/N 0334E N369KDDairy Air LLC · Scottsdale, AZBuilt 1983 · S/N 0037E N369KVAgricultural Air Services LLC · Jupiter, FLBuilt 1980 · S/N 300659D N369LRCenterline Holdings Inc · Camden, DES/N 610991D N369MHAa Leasing Lp · Kilauea, HIBuilt 1978 · S/N 380287D N369MPAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 670150D N369PBHelicopter Aviation Services & Leasing Inc · Miami, FLBuilt 1978 · S/N 480305D N369PDCity Of Atlanta · Atlanta, GABuilt 2001 · S/N 0721FF N369SCVertical Flight Path LLC · Wilmington, DES/N 380273D

Back to AD 2002-13-05 R1