Registered aircraft · 16,284

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.

N89CRWsg Aviation LLC · Chaffee, MOBuilt 2007 · S/N 2365 N89FJS-Turns LLC · Windermere, FLBuilt 2015 · S/N 4238 N89GHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1178 N89HRDechent Christopher M · Wingdale, NYBuilt 2001 · S/N 1112 N89KCFitzpatrick Tod · Las Vegas, NVBuilt 2009 · S/N 411123 N89KTSmelcer Jason · Necedah, WIBuilt 2018 · S/N 2453 N89KWThelen Mark C · Roswell, GABuilt 2007 · S/N 2492 N89LF6fathoms Consulting LLC · Spicewood, TXBuilt 2022 · S/N 8569 N89MNNoffze Michael · West Fargo, NDBuilt 2024 · S/N 10378 N89MVLegacy Aviation Trust Holdings Corp Trustee · Doral, FLS/N BB-766 N89NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 3680 N89NXCardinal Account Services Inc DBA · Mentor, OHBuilt 2004 · S/N 1004 N89PBPb Mad Aviation LLC · Pittsburgh, PABuilt 2025 · S/N 11052 N89PMLittle Dreams Aviation LLC · Washingtn Twp, MIBuilt 2013 · S/N 4636613 N89PWTaylor Aviation Services LLC · Charlottesville, VABuilt 2009 · S/N 4697384 N89SNRegistered aircraftBuilt 2026 · S/N 11446 N89UMIsbell Services LLC · Tuscaloosa, ALBuilt 2004 · S/N 0971 N8AEIflyu LLC · Mobile, ALBuilt 2008 · S/N 2999 N8AMMraf LLC · Wilmington, DEBuilt 1977 · S/N BB-274 N8EFMcco Inc · Tuscumbia, ALBuilt 1980 · S/N BB-721 N8KBBiddulph Oldsmobile Inc · Phoenix, AZBuilt 1978 · S/N BB-446 N8KTChui Aviation LLC · The Woodlands, TXBuilt 2020 · S/N 4900 N8LJFlying Mushrooms LLC · New York, NYBuilt 2023 · S/N 9323 N8NXExecutive Aviation Group Inc · Saint Petersburg, FLBuilt 1980 · S/N BB-774 N8NYTap Family Corp · Wilmington, DEBuilt 2002 · S/N 3257270 N8PYDeleon Christopher · Donna, TXS/N 1645 N8RGGrimes Raymond L Trustee · Los Alamitos, CABuilt 1979 · S/N 32R-8029012 N8UMSkytravel Inc · Houston, TXBuilt 2001 · S/N 4697067 N8UZAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 42050 N8VTAleph Leasing LLC · Eagle Mountain, UTBuilt 2005 · S/N 40.480 N8ZBEastern Nevada Aviation LLC · Gardnerville, NVBuilt 1997 · S/N 3257011 N8ZPDllm LLC · Chanhassen, MNBuilt 2016 · S/N 4343 N9003Andreotti Mark · Colusa, CABuilt 2005 · S/N 41074 N9003FStack Steven E · Santa Clarita, CABuilt 1976 · S/N 28-7790273 N900ACTurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N LW282 N900DAMurray Dennis E · Colorado Springs, COBuilt 2005 · S/N 40.590 N900GGVeetwo Inc · Merritt Island, FLS/N 3433020 N900MASdp Air Inc · Memphis, TNBuilt 2007 · S/N 4636406 N900PHSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-30302 N900SDSpot Aviation Ltd LLC · Wilmington, DES/N 32R-8013072 N901AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843801 N901BABismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N BB-674 N901CArchambault James M · Destin, FLBuilt 2010 · S/N 4692144 N901DMCordonnier Andrew · San Diego, CABuilt 2001 · S/N 4697051 N901FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 2842171 N901FFFlightline Holdings II LLC · New Orleans, LABuilt 1980 · S/N BB-637 N901GTS&L Motorsports LLC · Biloxi, MSS/N 3788 N901MAWings Of Ber LLC · Fort Payne, ALBuilt 2000 · S/N 46-36301 N901PASkywest Leasing Inc · St George, UTS/N 2843481 N901SESoutheastern Oklahoma State University · Durant, OKBuilt 2020 · S/N 2601

Back to AD 2008-06-28 R1