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.
N7702BSkyborne Airline Academy Inc · Vero Beach, FLN7702DAnderson Leonard M · Lakeside, MTN7702HPaphos Airways LLC · Farmingdale, NYN7702LPrp Enterprises LLC · Lake Forest, CAN7702MCullen William Edward · Mill Valley, CAN7702NN7702n LLC · Glenford, OHN7702WMud Duck LLC · Dover, DEN7703CEdb Air Inc · Wilsonville, ORN7703YNixon Christopher M · Washington, INN7703ZBarrett Jane T · Tehachapi, CAN7704DSkyborne Airlines Academy Inc · Vero Beach, FLN7704JTatum John T · Danville, ARN7704MCollins Benjamin N · Chapel Hill, NCN7704PDolin Irving M · Gardner, KSN7704WKelly John T III · Denison, TXN7704ZAerial Banners Inc · Pembroke Pines, FLN7705Ck Aviation LLC · Castle Pines, CON7705DPumphrey Ronald W · Houston, MSFirst renewal noticeN7705HNordic Flyers Inc · Plymouth, MNN7705NNagy Peter · Sebring, FLN7706NSealey John W · Athens, TXN7706YHighway Whisperer LLC · Wilmington, DEN77077Hammarback Inc · East Grand Forks, MNN7707GAtd Pilot Training LLC · Kansas City, MON7707JBowersox James · Lititz, PAN7707NAviation Trust Co LLC Trustee · Oklahoma City, OKN7707PSweitzer Cameron D · Warrensburg, MON7707WCockrell Amos L · Florence, ALN7707YLoveless John R Trustee · Bynum, TXN7708DR & R Hays Corp · Cody, WYN7708WCarter Veronica D · Mesa, AZN7709DAk8 Assets LLC · Talkeetna, AKN7709JSkyborne Airline Academy Inc · Vero Beach, FLN7709NGallette John B · Edgewood, NMN7709WNewlin Thomas R · Montezuma, INFirst renewal noticeN7709YBauer Aviation LLC · Reese, MIN770ASTyrrells Trails LLC · Fairbanks, AKN770BDJ/D Aviation LLC · Chisago City, MNFirst renewal noticeN770BHFernando Baeza · Anthony, NMN770BKHorizon Dreams LLC · Homer, GAN770DHBetzen Ethan W · Wichita, KSN770DKStanton Michael · Wilmington, NCN770DTBargemann Jeffrey Karl · Greenville, OHN770FTThornton Spencer A · Patchogue, NYN770GCareer Pilot Training LLC · Wilmington, DEN770JLWirt David L · Bowling Green, OHN770KTInterprime Air Inc · Doral, FLN770NDN770nd LLC · Sidney, MTN770PRPuerto Rico International Airline Inc · Santurce, PRN770RPRipka James H · Grasonville, MD
Back to AD 87-10-06 R1