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.

N48PDCrown Of Texas Ventures LLC · Panhandle, TXS/N 41002N48PRBadrow Allan R · Warrenton, VABuilt 2002 · S/N 2843533N48RCMonson Horizon Inc · Reynolds, ILS/N 3420N48REMountain Tide LLC · North Bend, ORBuilt 2002 · S/N 0404N48TGPlane Sales LLC · Troy, MIBuilt 2006 · S/N 1637N48VUJackpot Air LLC · Avon, INBuilt 2018 · S/N 2446N48WPlatina Investment Corporation · Oklahoma City, OKBuilt 1977 · S/N LW-254N4900JUniversal Technical Institute Inc · Avondale, AZBuilt 1968 · S/N 28R-30617N4900URegistration Pending · Rockville, MDRegistration pendingBuilt 2005 · S/N 2842240N4904N4904 LLC · Lithia, FLBuilt 2008 · S/N 2924N4904JLunken Air Group LLC · Cincinnati, OHS/N 28R-30622N4905JMoore Albert III · Las Vegas, NVBuilt 1968 · S/N 28R-30623N4906JSeal Air LLC · San Juan Capo, CABuilt 1968 · S/N 28R-30624N4907JHarmon Neil A · North Chelmsford, MABuilt 1968 · S/N 28R-30625N4908JHolm R Stan · College Place, WABuilt 1968 · S/N 28R-30626N490CDGiron Mercedes · Atlanta, GABuilt 2005 · S/N 1559N490CESkyward Capital LLC · Monona, WIBuilt 2022 · S/N 8515N490DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1836N490PGRegistered aircraftBuilt 2008 · S/N 1971N490SRSki Town Transport LLC · Jackson, WYBuilt 2007 · S/N 2840N490SUSeries D Of Boelte Aviation LLC · Wilmington, DEBuilt 2024 · S/N 10032N4910JGyure Ronald J · Fort Worth, TXBuilt 1968 · S/N 28R-30629N4912JWallace William R · Fredericksburg, TXFirst renewal noticeS/N 28R-30631N4915JFox Richard A · Boynton Beach, FLBuilt 1968 · S/N 28R-30634N4916JRegistration Pending · Townsend, GARegistration pendingBuilt 1968 · S/N 28R-30635N4917AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496254N4917JTendall Timothy A · Sudbury, MABuilt 1968 · S/N 28R-30637N4918JWoolley Charles K · Clarksville, TNBuilt 1968 · S/N 28R-30638N491AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9333N491DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1837N491NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496236N491SGryphon Ventures LLC · Apollo Beach, FLBuilt 2003 · S/N 0491N491TCWingsleasing LLC · Wichita, KSBuilt 2008 · S/N 40.914N4921JHerdrich Sean D · Manchester, IABuilt 1968 · S/N 28R-30642N4922JOpat Randall J · Port Saint Lucie, FLS/N 28R-30643N4924JCarper Clyde S · New Port Richey, FLBuilt 1968 · S/N 28R-30645N4927N774pt Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2598N4929JBurnett Robert E · San Leandro, CABuilt 1968 · S/N 28R-30650N492AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9361N492BCConsumer Collection Management Inc · Saint Louis, MOBuilt 2005 · S/N 3255037N492CPCirrus Velocity Group LLC · San Antonio, TXBuilt 2008 · S/N 3309N492DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1838N492DMDunaway Brian Scott · Perry, GABuilt 2008 · S/N 3282N492DSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.504N492FZFishkind Aircraft Holding LLC · Orlando, FLBuilt 2019 · S/N 4697663N492NDChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496241N4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241N4930VCirrusly LLC · Bonney Lake, WABuilt 2004 · S/N 0960N4932JDunlap Aviation Inc · Dunlap, ILBuilt 1968 · S/N 28R-30653N4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1968 · S/N 28R-30654
Back to AD 2008-06-28 R1