Registered aircraft · 72,007

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.

N30184Cp Aviation Inc · Santa Paula, CABuilt 1974 · S/N 17264125 N30189Onguard Aviation LLC · Cottonwood Falls, KSBuilt 1968 · S/N 17701108 N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398 N30190N30190 LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7887272 N30195Palmer Peter L · Mission, TXBuilt 1968 · S/N 17701113 N30198Thomas Mark J · Vacaville, CABuilt 1968 · S/N 17701115 N3019KColorado Air LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7987089 N3019LWatkins Daniel J · Kennett Square, PABuilt 1983 · S/N 7-0136 N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928 N3019TDanner Eric C · Benton, KSBuilt 2007 · S/N 23099C N3019YSheets Jeffrey M · Salmon, IDBuilt 1979 · S/N 28-7911148 N301ACFlying Squirrel Aviation LLC · Shirley, MABuilt 1995 · S/N 744-95 N301AVJackson Charles A · Winchester, KYBuilt 1976 · S/N 28-7715070 N301BHTraxler Shane C · West Monroe, LABuilt 1997 · S/N 3246080 N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284 N301BPPrecision Aviators LLC · Iuka, ILBuilt 1991 · S/N 1983 N301CAFreiday Robert A · Kingman, AZBuilt 1967 · S/N 32-40178 N301DETentacle Corp · Walnut Creek, CABuilt 1997 · S/N 041 N301DTDawson Taylor Enterprises LLC · Dover, DEBuilt 1998 · S/N 0081 N301EHinckley Harry W · Coralville, IABuilt 1989 · S/N 62 N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980 N301EMMcconwell Edward A · Mission, KSBuilt 1965 · S/N 30-916 N301FSNadh Development LLC · Santa Rosa, CABuilt 2022 · S/N 1565 N301HEN301he LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2382M N301JCGardner Jeffrey · Reno, NVBuilt 1980 · S/N 18267770 N301JKKaminski John J · Torrance, CABuilt 1978 · S/N 24-0634 N301JRTropitech Inc · San Juan, PRBuilt 1973 · S/N 17261555 N301JSOlson Nicholas D · Ankeny, IABuilt 1993 · S/N JS001 N301KARivard Robert M · Grand Haven, MIBuilt 1981 · S/N 32R8113020 N301KCRidl Kent S · West Fargo, NDBuilt 1978 · S/N 24-0414 N301KG217 Aviation LLC · Winchester, ILBuilt 1988 · S/N 3213017 N301KKBurris Timothy J · Fountain Inn, SCBuilt 1979 · S/N 32-7940092 N301MXRockin T Construction Inc · Swan Valley, IDBuilt 1998 · S/N 1391 N301NDPutzke Becky A · Fort Ripley, MNS/N 17261763 N301NLHammerhead Holdings LLC · Manassas, VABuilt 1998 · S/N 067 N301PKHubbs Matthew · Huntersville, NCBuilt 1973 · S/N 32-7440064 N301PS3b1g Enterprises LLC · Phoenix, AZBuilt 1982 · S/N 32-8306007 N301RTSather Dean L · Amarillo, TXBuilt 1982 · S/N 32R-8229068 N301SMCameron Ottis W · Comfort, TXFirst renewal noticeBuilt 1964 · S/N 534 N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655 N301TMTlwm Private Air LLC · Tampa, FLBuilt 1991 · S/N 27-0123 N301TXSpitfire Aviation Inc · Wilmington, DEBuilt 1995 · S/N 1712 N301WHWedekemper Steven E · Brighton, MIBuilt 2002 · S/N 150 N3020MWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995220 N3020SAndre Frazier LLC · Anacortes, WABuilt 1979 · S/N 28-7916295 N3020WDague John · Monroe, INS/N 28R-7918087 N3020ZCapece Richard N · Leonardtown, MDS/N 22-6972 N30218Mckillip Kirby G · Kemah, TXBuilt 1968 · S/N 17701127 N3021CUnited States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28-7916137 N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405

Back to AD 87-10-06 R1