OpenAirDocs.org
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
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.

N3079USpicher Samuel C Jr · Harrisonburg, VABuilt 2004 · S/N 2843591N307AHadaway Phillip Allen · Hooks, TXBuilt 2006 · S/N 1913N307AFImmaterial Hedgehog LLC · Los Angeles, CABuilt 2009 · S/N 40.1055N307AG4th Down Aviation LLC · Provo, UTBuilt 2006 · S/N 41595N307CDBarton Michael · Creve Coeur, MOBuilt 2004 · S/N 1092N307CPCirrus R50 LLC · Shreveport, LABuilt 2008 · S/N 3228N307DMBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N BB-332N307JRSatellite Radio Management Inc · Hays, KSBuilt 2005 · S/N 41513N307NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881617N30823Indian Hills Community College · Ottumwa, IAS/N 28-7816548N30834Tribec Group International Inc · Medina, OHBuilt 2004 · S/N 3255019N30877Pompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1978 · S/N 28-7890457N3088HDon Abney Inc · Patterson, LABuilt 2007 · S/N 3257465N30898Painter Andrew S · Harlingen, TXBuilt 2005 · S/N 4697202N308CDM&R Transport LLC · Dover, DEBuilt 2004 · S/N 1026N308FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020108N308JJjc Air LLC · Normandy Beach, NJBuilt 2024 · S/N 10359N308JSCirrus Design Corp · Duluth, MNBuilt 2023 · S/N 9236N308LSpirit Aviation LLC · Dunedin, FLS/N 2065N308MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010011N308PAMach 5x LLC · Sheridan, WYBuilt 2026 · S/N 11155N308STAero Mobil Inc · Wilmington, DEBuilt 2007 · S/N 4697308N3090AFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496183N3090KDepuy James · Ridgefield, CTBuilt 2009 · S/N 4697396N3092JJett-A Aviation LLC · Houston, TXBuilt 2008 · S/N 3257487N3092SDavidson Robert I · Coeur D Alene, IDBuilt 2004 · S/N 3257366N3093FChurchill Air LLC · Jamestown, NYBuilt 2004 · S/N 3246221N30947Silver Palms Aviation LLC · Miami, FLBuilt 2004 · S/N 3257367N3094RDrygala Marcin M · Williamsburg, VABuilt 2005 · S/N 3257388N3094WSeneca Flight LLC · Gosnell, ARBuilt 2005 · S/N 3255038N3094YSale Reported · Sugar Land, TXSale reportedS/N 3257389N3095GLas Piedras LLC · Englewood, COBuilt 2008 · S/N 4692065N3096BRogers Aviation Inc · Mundelein, ILS/N 2843601N3096MFeatherston Samuel Lewis · Lyons, GABuilt 1977 · S/N 28-7890294N3096PV V I P LLC · Cottonwood, AZBuilt 2004 · S/N 4697178N3098365 Whiskey Romeo LLC · Timnath, COBuilt 2004 · S/N 4697189N3098HIcarus Be Damned LLC · Algonquin, ILBuilt 2007 · S/N 3257478N3098NValiair Lc Trustee · Casper, WYBuilt 2004 · S/N 4636357N30999Ruckel Philip P · Burlington, MABuilt 1978 · S/N 28-7816550N3099ELustig Consulting LLC · Mount Pleasant, SCBuilt 2005 · S/N 3257382N3099LJsn Aviation LLC · Ocala, FLBuilt 2005 · S/N 3255032N309CACloud Niner LLC · Levittown, NYBuilt 2026 · S/N 11198N309CDTriangle Aviation LLC · Cary, NCBuilt 2004 · S/N 1104N309CPCirrus 497pg LLC · Scottsdale, AZBuilt 2008 · S/N 3232N309FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020109N309FBAbbey Brook LLC · Venetia, PABuilt 2019 · S/N 2485N309FFAgee Greg · Huntington, WVBuilt 1977 · S/N 28-7790492N309HWWolfe Rentals LLC · Milwaukie, ORBuilt 2013 · S/N 4636612N309JFRozo Matthew · Chatsworth, CABuilt 2002 · S/N 0266N309JLHangar 15 LLC · Saint Martinville, LABuilt 2008 · S/N 411010
Back to AD 2008-06-28 R1