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.

N4401PCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881204 N4401UCae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2019 · S/N 2881239 N4401WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881240 N4402ACae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881241 N4402TCae Aviation Academy Phoneix LLC · Mesa, AZBuilt 2013 · S/N 2843717 N4402UCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843718 N4403LCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843721 N4403WCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843725 N4403ZCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843726 N4405ECae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496339 N4405JCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496340 N4405KCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496341 N4405NCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496342 N4405QCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496343 N4407XRegistered aircraftS/N 28-7690010 N4409XKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1975 · S/N 28-7690011 N440AAFms Bank · Fort Morgan, COBuilt 2019 · S/N 2881254 N440AJRocky Mountain College · Billings, MTBuilt 2019 · S/N 2881094 N440CDN440cd LLC · Williamsburg, VABuilt 2005 · S/N 1515 N440EHSurdex Corp · Chesterfield, MOBuilt 1986 · S/N 441-0358 N440FTAviation Express Inc · Greenville, WIBuilt 1982 · S/N 28-8216219 N440GTOlufsen Niels · Lakeway, TXBuilt 2006 · S/N 4636399 N440JPBernstein Robert L Trustee · La Jolla, CABuilt 2002 · S/N 40.233 N440MKAtp Aircraft 8 LLC · Wilmington, DEBuilt 2001 · S/N 4496068 N440NDPars Avn Corp · Wilmington, DEBuilt 2006 · S/N 2842271 N440PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496084 N440TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020191 N440TMMoeser David J · Naperville, ILBuilt 2008 · S/N 411028 N440UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020162 N4411XVandelay Aviation LLC · San Diego, CABuilt 1975 · S/N 28-7690013 N4414XMellett Aircraft Inc · Ambler, PABuilt 1975 · S/N 28-7690005 N44191C H Aviation Services Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N 28-7690330 N441ABank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 441-0094 N441ABPistol Aviation LLC · Anaconda, MTBuilt 1981 · S/N 441-0284 N441ADDch LLC · Grants Pass, ORS/N 4410226 N441AQM & M Aircraft LLC · Mankato, MNBuilt 1981 · S/N 4410203 N441BBMountain Sand Investment LLC · Wilmington, DEBuilt 1981 · S/N 441-0217 N441BDN441bd LLC · Anchorage, AKS/N 4410086 N441BFAmt Services Leasing Co Inc · Colorado Springs, COS/N 441-0145 N441BKBek Consulting LLC · Dickinson, NDBuilt 1981 · S/N 441-0215 N441BLZero Zero LLC · Enterprise, UTBuilt 1981 · S/N 4410237 N441BWWisconsin Aviation Inc · Watertown, WIS/N 441-0034 N441CCNoem Troy · Grand Junction, COBuilt 1977 · S/N 441-0008 N441CJNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1979 · S/N 441-0117 N441CSNorton Aviation LLC · Longboat Key, FLBuilt 2006 · S/N 41596 N441CTAberdeen Flying Service · Aberdeen, SDBuilt 1978 · S/N 441-0048 N441DDGana Trucking & Excavating Inc · Martell, NES/N 4410341 N441DNSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 441-0325 N441DSWiley Equipment Leasing LLC · Leucadia, CABuilt 1978 · S/N 441-0028 N441DVAbn Air LLC · Ridgway, COBuilt 1980 · S/N 441-0166

Back to AD 2008-06-28 R1