Registered aircraft · 22,413

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N30877Pompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1978 · S/N 28-7890457 N3087RCrest Aviation LLC · Palmer, AKS/N 28R-35646 N3087TArroniz Valentin · San Juan, TXBuilt 1972 · S/N 28-7225542 N3088HDon Abney Inc · Patterson, LABuilt 2007 · S/N 3257465 N3089RFly Bms LLC · Elkton, SDBuilt 1969 · S/N 28R-35649 N3089THalverson Wyatt · Colbert, WABuilt 1972 · S/N 28-7225545 N308BEAlge Aviation Inc · Middletown, DES/N 32R-7780110 N308DFCangiano Lorene D · Agua Dulce, CAS/N 32-7840015 N308FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020108 N308MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010011 N3090QLarsen Wayne C · Tremonton, UTBuilt 1977 · S/N 28R-7703090 N3090RCasper Clarence Jr · Groton, CTBuilt 1969 · S/N 28R-35648 N30919Callahan Aviation LLC · Clearwater, FLBuilt 1978 · S/N 32-7840125 N3091TSutton Aircraft Salvalge LLC · Palmer, AKBuilt 1972 · S/N 28R-7235312 N3092JJett-A Aviation LLC · Houston, TXBuilt 2008 · S/N 3257487 N3092SDavidson Robert I · Coeur D Alene, IDBuilt 2004 · S/N 3257366 N3092TTango LLC · Quaker Hill, CTBuilt 1972 · S/N 28R-7235313 N3093FChurchill Air LLC · Jamestown, NYBuilt 2004 · S/N 3246221 N30947Silver Palms Aviation LLC · Miami, FLBuilt 2004 · S/N 3257367 N3094RDrygala Marcin M · Williamsburg, VABuilt 2005 · S/N 3257388 N3094WSeneca Flight LLC · Gosnell, ARBuilt 2005 · S/N 3255038 N3094YSale Reported · Sugar Land, TXSale reportedS/N 3257389 N30956Ought To Fly Inc · Litchfield, ILBuilt 1978 · S/N 32R-7885092 N3096BRogers Aviation Inc · Mundelein, ILS/N 2843601 N3096MFeatherston Samuel Lewis · Lyons, GABuilt 1977 · S/N 28-7890294 N3098HIcarus Be Damned LLC · Algonquin, ILBuilt 2007 · S/N 3257478 N30999Ruckel Philip P · Burlington, MABuilt 1978 · S/N 28-7816550 N3099ELustig Consulting LLC · Mount Pleasant, SCBuilt 2005 · S/N 3257382 N3099LJsn Aviation LLC · Ocala, FLBuilt 2005 · S/N 3255032 N3099RMesserschmidt Brent L · Gainesville, GABuilt 1969 · S/N 28R-35668 N309FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020109 N309FFAgee Greg · Huntington, WVBuilt 1977 · S/N 28-7790492 N309MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010015 N309NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881781 N309PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 2843508 N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229 N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100 N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018 N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098 N31008China Saratoga Airline Inc Trustee · Wilmington, DEBuilt 2005 · S/N 3246229 N3100QFly By Nite Aviation LLC · Great Falls, MTS/N 28R-7703091 N31082Bershire Aviation Enterprises LLC · Great Barrington, MAS/N 28-7816551 N31087Lvr Air Inc · East Hartford, CTBuilt 2005 · S/N 3232044 N3109PSoft Works Systems Inc · Jamesville, NYBuilt 1969 · S/N 28R-31109 N310EFMatherne Aviation LLC · Houma, LABuilt 1975 · S/N 28-7515300 N310EVMission Air Capital Services LLC · San Antonio, TXBuilt 1978 · S/N 32-7940024 N310GSKnot So Fast Aviation Inc · Kernersville, NCBuilt 1979 · S/N 28-8090140 N310MAMbm Leasing LLC · Saint Louis, MOBuilt 2023 · S/N 28020104 N3111CSalt Air Aviation LLC · Chapel Hill, NCBuilt 2006 · S/N 3232057 N31122Ross Jeremy · Lufkin, TXBuilt 2005 · S/N 3257394

Back to AD 87-08-08 R3