Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,280

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N4329PDunn Danvil L · East Meadow, NYBuilt 1983 · S/N 28-8490022 N432CBAlltrade Aviation LLC · Fort Branch, INBuilt 2004 · S/N 1175 N432CDVlahos Aviation LLC · Destin, FLBuilt 2004 · S/N 0941 N432DRJazz Air LLC · Melbourne, FLBuilt 1997 · S/N 3246084 N432DSButler Jeffrey W · Santaquin, UTBuilt 2001 · S/N 40032 N432HPFuehrer Wyatt R · Coatesville, INBuilt 1977 · S/N 28-7790547 N432JATottino David · Coachella, CABuilt 2008 · S/N 411046 N432KCKjomo Aviation LLC · Ocean Springs, MSBuilt 2004 · S/N 3246225 N432LLBuckingham Aero LLC · Buckingham, VABuilt 2006 · S/N 3257432 N432SAMma Consulting Inc · Chestnut Hill, MABuilt 2002 · S/N 3449232 N432SCChalfin Steven · San Antonio, TXBuilt 2001 · S/N 40049 N432WBRb432 Investments LLC · Naples, FLBuilt 2022 · S/N 8725 N432WWMiller Kris K · Cary, NCFirst renewal noticeBuilt 1982 · S/N 28-8390009 N4330DHildebrand David S · Albuquerque, NMBuilt 1983 · S/N 28-8490026 N43314Gardners Guns & Mfg LLC · Elk City, OKBuilt 1984 · S/N 28-8490029 N4331CLance Air Inc · Taylorsville, KYBuilt 1983 · S/N 32R-8413004 N4331MNieves Osvaldo Colon · San Juan, PRS/N 28-8416028 N4331PWilson Cecil · Lithonia, GABuilt 1983 · S/N 28-8416029 N4332LRubman Tracy L · Shelburne, VTBuilt 1983 · S/N 28-8416031 N4332NThree Wing Flight School LLC · Stratford, CTBuilt 1983 · S/N 28-8416034 N4333AAir-Mods Flight Academy Inc · Robbinsville, NJBuilt 1983 · S/N 28-8416037 N4333BLand & Leave LLC · Helena, MTBuilt 1983 · S/N 28-8416038 N4333CSmart 02 LLC · Kissimmee, FLBuilt 1983 · S/N 28-8416039 N4333GHuebscher Attila · Pittstown, NJBuilt 1984 · S/N 34-8433048 N4334BRed Five Air LLC · Stuart, FLBuilt 1984 · S/N 28-8490036 N4334V305 Aviation Group Inc · Miami, FLBuilt 1984 · S/N 28-8490039 N4334XOxford Flying Club Inc · Oxford, CTBuilt 1984 · S/N 28-8490040 N4335DSparrowhawk Aviation LLC · Hollister, CABuilt 1984 · S/N 28-8490043 N4335KDodge Colleen Marie · Lake Geneva, WIBuilt 1984 · S/N 28-8490044 N4336GIn The Air Tonight LLC · Strasburg, OHS/N 32R-8413005 N4337FEarly Bird Aviation LLC · Phoenix, AZBuilt 1976 · S/N 28-7790016 N4337VThunderbird Aircraft Co · Bloomington, MNBuilt 1984 · S/N 28-8416045 N4338FSzmagala Taras G Jr · Bentleyville, OHBuilt 1976 · S/N 28-7790017 N4338MAndrews University · Berrien Springs, MIS/N 28-8490048 N4338NMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490049 N4338PTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1984 · S/N 28-8490050 N4338VFlying Mermaid LLC · Aiea, HIBuilt 1984 · S/N 28-8490052 N4339WArora Three Nine Whiskey LLC · Bel Air, MDBuilt 1983 · S/N 32R-8413008 N433ALBowline Aviation LLC · Jupiter, FLBuilt 2026 · S/N 11357 N433BVBerit Merkab LLC · Monroe, NCBuilt 2025 · S/N 10455 N433CFRotormate LLC · Royse City, TXS/N 0710 N433CPPaul Family Properties - Texas LLC · Wasco, CABuilt 2008 · S/N 3070 N433DSRnp Capital Holdings LLC · Corpus Christi, TXBuilt 2001 · S/N 40033 N433KANun-Yuh Business LLC · Kuna, IDBuilt 2023 · S/N 9170 N433MCirrus Design Corp · Duluth, MNS/N 11656 N433MASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 28-43362 N433MCMichael W Miller LLC · Wilmington, DEBuilt 2011 · S/N 4636512 N433MJCousin Elisabeth Trustee · Pompano Beach, FLBuilt 2004 · S/N 1469 N433PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496063 N433PJHotel Golf Aviation LLC · Brownfield, TXBuilt 2005 · S/N 4697198

Back to AD 2008-06-28 R1