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.

N441TNPure Aviation Leasing LLC · Las Vegas, NVBuilt 1979 · S/N 4410085 N441UCConquest Associates LLC · Concord, MAS/N 4410344 N441VTraveling Alana Inc · Key Largo, FLBuilt 1983 · S/N 4410322 N441VHWe Fly LLC · Fort Payne, ALBuilt 1981 · S/N 441-0225 N441VMVitality Aviation LLC · Aitkin, MNS/N 441-0361 N441WDJv Air LLC · Charlotte, VTBuilt 1979 · S/N 441-0107 N441WFRaber Flight Services LLC · Littleton, COS/N 4410115 N441WJCocoamo LLC · Merritt Island, FLS/N 441-0194 N441WLVichy Enterprises LLC · Wilmington, DEBuilt 1978 · S/N 441-0041 N441WTHaven Air LLC · Winter Garden, FLBuilt 1983 · S/N 441-0313 N441XMatosich Andrew J · Bigfork, MTS/N 441-0254 N4421XN4421x LLC · Sarasota, FLBuilt 1975 · S/N 28-7690007 N4428LAltenpohl LLC · High Point, NCBuilt 2014 · S/N 4636628 N4429FMc Leasing LLC · Delta, UTBuilt 2014 · S/N 4636644 N4429THeartland Air Leasing LLC · Coon Rapids, MNBuilt 2014 · S/N 4697571 N442BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 4496460 N442CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881131 N442ED&S Aviation LLC · Yakima, WABuilt 1982 · S/N 32R-8213042 N442GMLancaster Aviation LLC · Chicago, ILS/N 2257 N442HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 4496056 N442JSPrelude Aviation LLC · Rockledge, FLBuilt 2024 · S/N 9948 N442KAMoore Horizons LLC · Murrells Inlet, SCBuilt 1978 · S/N BB442 N442LCKnudtson Kirk · Kasson, MNBuilt 1978 · S/N 28-7890455 N442MKG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995301 N442PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843498 N442RMRocky Mountain College · Billings, MTBuilt 2013 · S/N 4496347 N442SAG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 44-7995071 N442SCTrixies Entertainment LLC · Lowell, ARS/N 32R8113118 N442SJRegistered aircraftBuilt 2006 · S/N 42521 N442TAN6105s LLC · Norwood, NCS/N 41532 N442TTQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1012 N442ZCowan Holdings Management LLC · Gaylord, MIBuilt 2011 · S/N 40.1124 N4438TAlf Ix LLC · Chicago, ILBuilt 2015 · S/N 4496388 N4438UAlf Ix LLC · Chicago, ILBuilt 2015 · S/N 4496389 N443BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 4496491 N443CLSkiing Aircraft Co LLC · Bloomfield Hills, MIBuilt 1979 · S/N LW-318 N443CPBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3296 N443FCFlyfry Montana LLC · Kalispell, MTBuilt 2023 · S/N 9227 N443MGGeorgia Aviation Authority · Eastman, GAFirst renewal noticeBuilt 2017 · S/N 4496400 N443MKNorth Star Aviation · Mankato, MNBuilt 2015 · S/N 4496382 N443PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843499 N44426Skyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842396 N4443QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842397 N4444EIllsley Roger J · Santa Rosa, CABuilt 1976 · S/N 28-7690250 N4445JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842398 N4445KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842399 N4445PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842400 N4445SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842401 N4445VSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842402 N4445YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842403

Back to AD 2008-06-28 R1