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.

N6007VHauser Scott · Towanda, PABuilt 1971 · S/N 31024 N6007WMoore Merritt · Mcarthur, CAS/N 28-20007 N6007YAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1978 · S/N M-2130 N6007ZSharkey John F III · Oswego, NYBuilt 1992 · S/N 14555 N60083Kocik William J Jr · Shepherdstown, WVBuilt 1978 · S/N M-2083 N60086Echo Bravo LLC · Helena, MTBuilt 1978 · S/N MC-617 N6008DChristopher D Bock · Fishers, INBuilt 1979 · S/N MC-611 N6008HSwartz Selden H Jr · Jacksonville, ORBuilt 1977 · S/N 28R-7837047 N6008KShore Stephen · Longview, TXBuilt 1981 · S/N M-2086 N6008LGawlik Leslie W · Reisterstown, MDBuilt 1978 · S/N M-2087 N6008URasmussen John E · Seffner, FLBuilt 1978 · S/N MC-616 N6008XMangum Gary W · Centreville, VABuilt 1969 · S/N 301836 N60096Barto Jerrel · Kula, HIBuilt 1992 · S/N 14552 N60097Ratliff Frank O · Palestine, TXBuilt 1978 · S/N MC-619 N6009ACampbell Bryan P · Naples, FLBuilt 2009 · S/N 91170 N6009DKirkendall James A · N Richland Hills, TXS/N 22-4661 N6009QDelone Charles P · Sarasota, FLBuilt 1965 · S/N 863 N6009WLowman Jeffrey L · Clarksburg, WVBuilt 1964 · S/N 28-20009 N600AABrauer Jason R · Winnebago, ILBuilt 1968 · S/N 28-25102 N600AGBisignano Michael · Palm Coast, FLBuilt 1989 · S/N 4622053 N600AHCoastal Road Aviation LLC · Mukilteo, WABuilt 1969 · S/N 24-4863 N600AVMountain Top Aviation Inc · Ebensburg, PABuilt 1978 · S/N 28-7916229 N600AZDykema Carl F · Davie, FLBuilt 1969 · S/N 61-0022 N600BAJacks Express LLC · Wilmington, DEBuilt 1982 · S/N 60-8265024 N600BHBeaupre Harry R · Fallon, NVBuilt 2003 · S/N 2330 N600CJPoly Plastics Inc · Owatonna, MNBuilt 1978 · S/N 32R-7885050 N600CRSilver Throne Aviation LLC · Anchorage, AKBuilt 1989 · S/N 4622060 N600CWWinn Kathy J · Spring, TXBuilt 1994 · S/N 20755 N600EDWeskalnies Michael · Jarrettsville, MDBuilt 1969 · S/N 60-0013 N600FABeaver Creek Adventures LLC · Bangor, MEBuilt 1975 · S/N 60-0246-101 N600FSHome Free Aviation LLC · New Port Richey, FLBuilt 1974 · S/N 22-0044 N600GGNlh Aviation LLC · College Station, TXBuilt 1980 · S/N 394-80 N600HHFleming Mike R · Troy, MOBuilt 1974 · S/N 600 N600HJRavotti Air LLC · Leechburg, PABuilt 1978 · S/N 28-7990004 N600JGWiltcher Christopher Alex · Gallatin, TNBuilt 1969 · S/N 32-40726 N600JKMcdonald Harry · Toccoa, GABuilt 1975 · S/N 60-0257-104 N600JLMinisterio Internacional Gracia Y Poder Inc · Houston, TXBuilt 1973 · S/N 32-7400010 N600KKFeielin Kenneth M · Paris, OHBuilt 2007 · S/N 25488 N600NJKralta Enterprises LLC · Sioux Falls, SDBuilt 1975 · S/N 60-0199-088 N600PCRudd Wayne · Basalt, COBuilt 1993 · S/N 714-93 N600PFEastern Aviation Corp · Whitestone, NYBuilt 1977 · S/N 28-7816109 N600RSavanna Lakes LLC · Dover, DEBuilt 1969 · S/N 60-0018 N600RBGates Steven · Midlothian, TXBuilt 1974 · S/N 247 N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114 N600SHReynolds Phillip Micah · Jefferson City, TNBuilt 1994 · S/N H002 N600SRCsd Enterprises Inc · Wilmington, DEBuilt 2000 · S/N 0751 N600TEHutter Charles G · Carson City, NVBuilt 1973 · S/N 61-0146-077 N600TLLbaviation LLC · Wheatland, WYS/N 1148 N600VFBravo Gulf LLC · Cleveland, OHBuilt 1980 · S/N 6007578061229 N600VVMindy Limited LLC · Muscatine, IABuilt 1975 · S/N 17264773

Back to AD 87-10-06 R1