Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674 N4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeBuilt 1976 · S/N 28-7790071 N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444 N4897WGibson Kurt A · Fort Smith, ARBuilt 1977 · S/N 14227 N4897YKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4704 N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097 N4898WSorce Angelo J · Dandridge, TNBuilt 1977 · S/N 14228 N4898YSimmons Mark Adba · Pawcatuck, CTBuilt 1968 · S/N 25-4705 N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446 N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266 N4899PC E S Corporation · Charleston, WVRevoked, canceledBuilt 1961 · S/N 27-487 N489ACKuza Flyers LLC · Rock Hill, SCBuilt 1999 · S/N 413-98 N489ALHehl Adam D · Anchorage, AKBuilt 1956 · S/N 18-4769 N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443 N489BJNo Air Services LLC · Holbrook, NYBuilt 1989 · S/N 2811028 N489CYW Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1973 · S/N 28-7310121 N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083 N489JOrr Matthew W · Kirkland, WAS/N 265 N489JEChambless Mardre F II · Panama City, FLBuilt 2004 · S/N 90508 N489LARed Baron LLC · Middletown, DES/N 47007T N489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083 N489RSViage LLC · Boston, MABuilt 2004 · S/N 40.379 N489RVBoyter Wayne · Winston, ORBuilt 2008 · S/N 21275 N489TJUnknown Media LLC · Cape Canaveral, FLS/N 3024 N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328 N48ASTheunissen Wilhelmus H · Oxnard, CABuilt 1998 · S/N 6007 N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064 N48BKKrebs Brian G · Hartland, WIBuilt 2012 · S/N 82136 N48BRField Christopher R · Kingston, TNBuilt 2009 · S/N 90951 N48BTMalone William · Mount Nebo, WVBuilt 1993 · S/N 5276 N48CDSky Helicopters Inc · Desoto, TXBuilt 2016 · S/N 30006 N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163 N48CLSharp Wade L · Asheville, NCS/N 21184 N48DFFuhrman Dennis M Trustee · Independence, ORBuilt 2020 · S/N 41653 N48DXSomers Andrew · El Paso, TXBuilt 2003 · S/N 386 N48ELRegistration Pending · Livermore, CARegistration pendingBuilt 2004 · S/N 1363 N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906 N48EWKucel Richard S · Dallas, TXFirst renewal noticeBuilt 1992 · S/N 5249 N48FHG-Stf LLC · Midland, TXBuilt 1979 · S/N R18201018 N48GHYellowstone Aviation Inc · Jackson, WYBuilt 1999 · S/N 2049 N48HAFiack Daniel P · Sun Valley, IDBuilt 1953 · S/N 22-975 N48HGJahn Glenn R · Torrance, CABuilt 2005 · S/N 70449 N48HTTurner Robert E · Castro Valley, CABuilt 2011 · S/N 40745 N48HYStruble Anne D · Springville, UTBuilt 2002 · S/N 2196 N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312 N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110 N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693 N48JWLee William L · Jonesborough, TNBuilt 1989 · S/N 2 N48KBRydberg Lawrence · Albuquerque, NMBuilt 1998 · S/N 26 N48KSHolcomb Garry M · Point, TXS/N PTS101

Back to AD 87-10-06 R1