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.

N4511FLewis Brett · Madison, NJBuilt 1976 · S/N 28-7790037 N4511JNoyes Tony · Lewisville, TXS/N 28R-30367 N4512FChase David B Trustee · Danville, CABuilt 1976 · S/N 28-7790038 N4512LA&J Aircraft Leasing Inc · Burlington, COS/N 28-8016016 N4513DRkm Aviation LLC · Lexington, NCBuilt 1979 · S/N 28-8090038 N4513JMalone Ronald · Englewood, TNBuilt 1968 · S/N 28R-30370 N4514JTrinity Aviation Ltd · Wilmington, DEFirst renewal noticeBuilt 1968 · S/N 28R-30371 N4515TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496115 N4516JFly By Nite Aviation LLC · Tampa, FLBuilt 1968 · S/N 28R-30373 N4518JFaizanali Hashme I · Middletown, OHBuilt 1968 · S/N 28R-30375 N451DSUtah State University · Logan, UTBuilt 2012 · S/N 40.1136 N451GLMaple Mountain Aircraft Leasing LLC · Payson, UTBuilt 2012 · S/N 40.1151 N451MAUpward Aviation LLC · Bridgeville, DEBuilt 2012 · S/N 4636541 N451MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 4496547 N451MVOne Mike Victor Aviation LLC · Belmont, CABuilt 2016 · S/N 4365 N451SPSacramento International Jet Center Inc · Sacramento, CABuilt 2003 · S/N 4636345 N451SRSkywalk LLC · Olive Branch, MSBuilt 2007 · S/N 2325 N451TJSr22 Aviators LLC · Crete, ILBuilt 2004 · S/N 0866 N451TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020140 N4520JRegistered aircraftBuilt 1968 · S/N 28R-30377 N4521JSpringer Louis A · Bellflower, CAS/N 28R-30378 N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028 N4523JN4523j LLC · Wilmington, DEBuilt 1968 · S/N 28R-30381 N4524FLwg Archer LLC · Reading, PABuilt 1976 · S/N 28-7790039 N4526FReabe Spraying Service Inc · Plover, WIBuilt 1976 · S/N 28-7790040 N4526JMcallister Aviation LLC · Richmond Hill, GABuilt 1968 · S/N 28R-30384 N4527JRegistration Pending · Cedar Hill, TXRegistration pendingS/N 28R-30385 N4528XChandler Agricultural Ind LLC Series Avation · Montgomery, ALBuilt 1975 · S/N 28-7690030 N452CDTimber Ridge Aviation LLC · Wilmington, DEBuilt 2010 · S/N 3652 N452JGQualitair LLC Trustee · MichelstadtS/N 1415 N452MDHeartsill Lucas G · San Angelo, TXBuilt 2016 · S/N 4426 N452PWDaniella Levi & Associates Pc · Fresh Meadows, NYBuilt 2004 · S/N 3246226 N452TXEfficient Transportation Services LLC · Harpers Ferry, WVBuilt 2015 · S/N 4233 N452VABegio Aviation LLC · Arlington, VABuilt 2019 · S/N 4776 N4531JQualitair LLC Trustee · MichelstadtBuilt 1968 · S/N 28R-30389 N4532JCohen Kyle Lee · Houston, TXBuilt 1968 · S/N 28R-30390 N4533XSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1975 · S/N 28-7690031 N4534JCartaya Lazaro C · Miami, FLS/N 28R-30393 N4535JMooney Executive Partnership · Kent, WABuilt 1968 · S/N 28R-30394 N4536JSale Reported · Merrill, WISale reportedBuilt 1968 · S/N 28R-30395 N4538QFlying V LLC · West Berlin, NJBuilt 1977 · S/N 28-7790476 N453AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8952 N453CDGizelbach Anthony · Newnan, GABuilt 2004 · S/N 1453 N453DS453ds Aircraft Leasing LLC · Spanish Fork, UTBuilt 2011 · S/N 40.1123 N453KCWindward Aviation Solutions LLC · Saint Marys, OHBuilt 1995 · S/N 3246015 N453MKNorth Star Aviation · Mankato, MNBuilt 2024 · S/N 4496579 N4540JDreyer Richard F · Springdale, ARBuilt 1968 · S/N 28R-30399 N4542JUht Christian M · Greenville, NYBuilt 1968 · S/N 28R-30402 N4545XMeier Gordon T · San Diego, CABuilt 1975 · S/N 28-7690033 N4547FSky Pilot Aviation Corp · Carlsbad, CABuilt 1976 · S/N 28-7790042

Back to AD 2008-06-28 R1