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.
N791TAerotwin Maui LLC · Kahului, HIN79201Universal Aviators Academy Inc · El Monte, CAN79202Jefts Larry G · Kunia, HIN79203Chupito Sabrocito LLC · Paso Robles, CAN79204Nexgen Aviation LLC · Ennis, TXN79207Swann Tawni K · Meridian, IDN79209Prp Aviation LLC · Ocala, FLN7920LOstrom Richard A · Sterling Hts, MIN7920NN7920n LLC · Sioux Falls, SDN7920PM & K Zeiler Aircraft LLC · Lawrence, KSN7920WJb III LLC · Stuart, FLN79212Hudson Rae Air LLC · San Marcos, CAN79213Hazelhurst Inc · Middletown, DEN79217Bone Cody A · College Station, TXN79219Caley Robert M · Green, KSN7921GTriad Aviation Academy LLC · Greensboro, NCN7921NBolin Paul C · Vancouver, WAN79220Cavu Flyers LLC · Trenton, SCN79222Davis John K · Texarkana, TXN79224Wolstenholme James L · Doylestown, PAN79227Elkins Pilots Club · Elkins, WVN79228Lowcountry Flying Club · Moncks Corner, SCN7922NMemo Air Services LLC · San Antonio, TXN7922PKeener & Assoc Inc · North Myrtle Beach, SCN7922WVouk Frank E · Firth, IDN7922YSuhrie Mark A · Oneida, KYN79233Sweeney Kathleen R · Hollister, CAN79234Aig Aeronautics LLC · San Juan, PRN79238Flightclub LLC · Jacksonville, FLN79239Custis James G · Friday Harbor, WAN7923BFishel Todd · Nineveh, INN7923LTolliver Richard R · Amery, WIN7923NGcc Aviation LLC · Elberton, GAN7923PRichards Michael Dean · Burneyville, OKN7924Staple K Aviation LLC · Queen Creek, AZN79241Stanley Aero Club Gastonia Inc · Belmont, NCN79244Wings Over Texas Holdings LLC · Denton, TXN79246Farrv LLC · Ogden, UTN79248San Hui Foundation · Denver, NCN79249Wings Over Texas Holdings LLC · Denton, TXN7924GHendrickson Burke · Kent, WAN7924PWest Texas Weather Modification Association · San Angelo, TXN7924WStumpner Van H · Warsaw, MON79255Angel Piper A · Mount Airy, NCN79256Mcdaniel Donald L · Tishomingo, OKN7925LAdams August G · Southport, NCN7925PJapundza Bob · Kokomo, INN79263Warner Richard M · Yellow Springs, OHN79264Vande Griend Scott M · Springfield, MON79268Hunt-Thornton Trevon · Aurora, CO
Back to AD 87-10-06 R1