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.

N4145AUniverstiy Of Illinois · Savoy, ILBuilt 1998 · S/N 2843150 N4145BBas Part Sales LLC · Greeley, COBuilt 1999 · S/N 34-49142 N4145GUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843151 N4145VGrassroots Aviation LLC · Norfolk, NEBuilt 2000 · S/N 3246165 N4145XUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843152 N4145ZJma Aviation LLC · Pompano Beach, FLBuilt 1999 · S/N 3246142 N41469Shield Solutions LLC · West Plains, MOBuilt 2000 · S/N 3257154 N4146DBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843153 N4146PN4146p Saratoga LLC · Austin, TXBuilt 1999 · S/N 3257106 N4146RUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843160 N4146TUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843168 N4147GStinson Aaron M · Anchorage, AKFirst renewal noticeBuilt 2000 · S/N 28-43364 N4147KUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843169 N4147NGeorge Robert J · Natick, MABuilt 1999 · S/N 3246131 N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272 N41480Tradewind Aviation Co Inc · Blue Bell, PABuilt 1999 · S/N 3246147 N41484Ferraro Jeffrey T · Mckinney, TXBuilt 1999 · S/N 4636234 N41487Skywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843179 N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170 N4148LFour 8 Lima LLC · Edgerton, OHS/N 3257084 N4148TChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496027 N4148VUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843178 N41492Charter Air Travel LLC · Mount Pleasant, SCBuilt 1999 · S/N 3257105 N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189 N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190 N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191 N4149RClary Daniela · Sunnyvale, TXBuilt 1999 · S/N 4636226 N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192 N414CKN414ck LLC · Tacoma, WABuilt 2009 · S/N 3414 N414CPCsu Aviation LLC · Plainfield, INBuilt 2008 · S/N 3209 N414TXKwb LLC · Dover, DEBuilt 2004 · S/N 1165 N41518Lechene Craig · Holly Springs, NCBuilt 2000 · S/N 46-36302 N4151PDaman Arthur C Trustee · Arroyo Grande, CABuilt 2000 · S/N 3257188 N4152DSires Brian · Cedar Falls, IABuilt 2000 · S/N 46-36304 N4152RRoby Richard J · Columbia, MDFirst renewal noticeBuilt 2000 · S/N 3246179 N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290 N41599Tiger Helicopters LLC · Baton Rouge, LABuilt 1999 · S/N 4636187 N415ABLee Thomas · Canton, GABuilt 2006 · S/N 1748 N415AMUtah State University · Logan, UTBuilt 2005 · S/N 40.517 N415BBAventra Aviation LLC · Fuquay Varina, NCBuilt 2006 · S/N 2083 N415BCTeichroeb Jacob · Seminole, TXBuilt 2014 · S/N 4697552 N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215 N415DJAms Enterprises Capital Holdings Inc · Newark, DEBuilt 2016 · S/N 4636710 N415GEN415ge LLC · Wilmington, DES/N 0693 N415GFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 0067 N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151 N415KGSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.483 N415KMTmjb Holdings LLC · Chandler, AZS/N 28-8390081 N415LXSew Belmont LLC · Laconia, NHBuilt 2015 · S/N 4225 N415MEEonm182 LLC · El Paso, TXS/N 41505

Back to AD 2008-06-28 R1