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.

N75304Rodamaker Craig M · Brainerd, MNBuilt 1976 · S/N 28-7690325N75305Hobbs Jonathan · Fort Mill, SCBuilt 1976 · S/N 28-7690326N7530JGarzon Aviation LLC · Cypress, TXBuilt 1968 · S/N 28R-30902N7531JN7531j LLC · Georgetown, TXBuilt 1968 · S/N 28R-30903N75320Strickland Plumbing Hvac And Electric Inc · Lufkin, TXS/N 28-7690329N7532JFedders Michael · Union, KYBuilt 1968 · S/N 28R-30905N75336Warthog Aviation Inc · Grand Island, NYBuilt 1978 · S/N 28-7890080N7534JMooney Christopher · Paris, TNBuilt 1968 · S/N 28R-30907N7535JHamel Ronald J · Milan, NHBuilt 1968 · S/N 28R-30909N7536JRicol Aviation LLC · Naples, FLBuilt 1968 · S/N 28R-30910N7537JGetsie Thomas A · Monroeville, PABuilt 1968 · S/N 28R-30911N75383Beaman Brice S · Alger, OHBuilt 1976 · S/N 28-7690335N75384Primost Brian C · North Brunswick, NJBuilt 1976 · S/N 28-7690336N753CGaviota Holdings LLC · Goleta, CABuilt 2006 · S/N 4697248N753JTFlight Time LLC · Norcross, GABuilt 2024 · S/N 10321N753MNR J Enterprise Inc · Newark, DEBuilt 2004 · S/N 41027N753NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881032N753PAN753pa LLC · Greenland, NHBuilt 2013 · S/N 3937N7544JHewitt Robert J · Ringwood, NJS/N 28R-30917N7545JP D Q Space Arrow Inc · Atlanta, GABuilt 1968 · S/N 28R-30918N7547JMiller Larry N · Warr Acres, OKBuilt 1968 · S/N 28R-30921N7548JSnider Steve P · Anacortes, WABuilt 1968 · S/N 28R-30922N754APPetrollini Alex · Mesa, AZS/N 2871N754BWN Waller & Associates Inc · Mobile, ALBuilt 1999 · S/N 2843233N754DJIsaiah 4031 LLC · Dexter, MNBuilt 2010 · S/N 3671N754NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881033N754RFAirtool LLC · Gardena, CABuilt 2009 · S/N 3378N754SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 2629N754WAGreenview Renewables LLC · Folsom, CABuilt 2019 · S/N 4636754N7551JKaercher Douglas A · Havre, MTBuilt 1968 · S/N 28R-30926N7553JThunder Arrow Corp · Santa Monica, CANon-citizen corporation, flight hours not reportedBuilt 1968 · S/N 28R-30929N7555JKeller Terry · Sedona, AZBuilt 1968 · S/N 28R-30931N7556JKern Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30933N7559JHale Edward L · Kingfisher, OKBuilt 1968 · S/N 28R-30937N755BEKilmartin Peter · Loudon, TNBuilt 1981 · S/N 32R-8213009N755CMelina Aviation Inc · Wilmington, DES/N 0392N755CABelieve It Two LLC · Sumter, SCBuilt 1996 · S/N 3246021N755CDCirus N755cd LLC · Aventura, FLBuilt 2001 · S/N 0121N755CPDardis Stanley K · Woodbury, MNBuilt 2008 · S/N 3174N755FGBarker Consulting Group LLC · Hickory, NCBuilt 2019 · S/N 4636755N755GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881206N755GSInfinitymail Corp · Pleasanton, CABuilt 2004 · S/N 0983N755HSAs Aviation LLC · Englewood, NJBuilt 2021 · S/N 5076N755JLCnh Investments LLC · Mahomet, ILBuilt 2009 · S/N 3403N755MBBoda Air LLC · Kalispell, MTBuilt 2008 · S/N 3197N755NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881034N755ZZPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 2827N7560JRankin Kevin J · Maryville, MOBuilt 1968 · S/N 28R-30938N7562JPrice Jesse L · Fargo, NDBuilt 1968 · S/N 28R-30940N7563JKring Neal A · Ash Flat, ARBuilt 1968 · S/N 28R-30941
Back to AD 2008-06-28 R1