AD 87-10-06 R1
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
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.
N83775Mattson Greg L · Alta, IAN8377FScott Shawn D · Darrington, WAN8377GKristoferson J S Md Custodian · Denton, TXN8377PGullett Samuel H · Lafayette, LAN8377RPerry Eden · Morgan Hill, CAN8377WRosenberg Adam N · Scottsdale, AZN83786Riggin Flight Service Inc · Madison, SDN8378ASoutheast Wings Ltd · Winston, GAN8378CCuller Hall Aeronautics LLC · Morrow, OHN8378HDiversified Aeronautical Svcs · Lake Ronkonkoma, NYN8378LLett Brian R · Eden Prairie, MNN8378PBel-Aire Home Restoration LLC · Platteville, WIN8378RNachbar Scott G · Springville, NYN8378YEmerald Aircraft LLC · Greenwood, SCN8379LSan Fernando Aviation LLC · Van Nuys, CAN8379WChilds Electric Inc · Dawson, GAN8379YSpaeth Alexander H · Aurora, ILN8379ZHawaii Pacific Aviation Inc · Kailua Kona, HIN837DSLyons Brent · Saint Cloud, FLN837ELHewitt Vehicles LLC · Oakford, INN837HBKellum Mark · Belden, MSN837KRouth Gary Lee · Lebanon, TNN837KTBeechsun LLC · South Jordan, UTN837PProfessional Training Aircraft LLC · Wilmington, DEN837PGG & G Comanche LLC · Magnolia Springs, ALN837PPIaba LLC · Norfolk, VAN837SCFf22 LLC · Scottsdale, AZN83808Jcl Aviation Inc · Palm Harbor, FLN8380CPittsburgh Pilot Training LLC · Bethel Park, PAN8380JMoritz Wagner P · Rochester, NYN8380LTroser Management Inc · Canandiaigua, NYN8380PGoins Eric M · Goldsboro, NCN8380UTrp Enterprises Inc · Mocksville, NCN8380VMaxwell Frank R · Fairbanks, AKN8380WForbes Aviation LLC · Boise, IDN83814Wachter Bruce · Maryville, TNN8381CIsley Gaylon B · Cedar Falls, IAN8381LShielded Holdings LLC - Series Av 12 · Katy, TXN8381PIndy Air Sales LLC · Anderson, INN8381VAurora Direct LLC · West Linn, ORN8381YLehrer James Rodd · Thief River Falls, MNN8382AAtd Pilot Training LLC · Kansas City, MON8382CSwickert Donald L II · Merritt Island, FLN8382EEastern Stearman Inc Trustee · Leesburg, VAN8382LMedina Solla Edwin O · Trujillo Alto, PRN8382PKutilek Emil J · Charlottesville, VAN8382WTrans Western Air Inc · Cullowhee, NCN8382ZMueller Charles G · Naples, FLN83831Connelly Christopher J · Lewiston, NYN83833Campbell Anna Lu · Sheridan, IL
Back to AD 87-10-06 R1