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.
N718BVVeillon Joseph B · Alexandria, LAFirst renewal noticeN718CPCivil Air Patrol · Maxwell Afb, ALN718DTherriault Ryan H · New London, NHN718DHWester Joshua C · Emmett, IDN718DRRead David A · Olney, ILN718EWKasza Daniel · Waterford, MIN718FLTubesing Gordon E · Palm Coast, FLN718HRMiller Glenn E · Albany, ORN718JRFlytwincos LLC · Las Vegas, NVN718KTGeorgia Aviation Authority · Eastman, GAN718MWescon Margin Inc · Wilmington, DEN718MJValiair Ltd Co Trustee · Casper, WYN718NDUnd Aerospace Foundation · Grand Forks, NDN718QCCoffee William Mike · Villa Rica, GAN718SCHelico Rotors Inc · Miami Beach, FLN718TETheis Timothy J · St Charles, ILN718TSSouthards Daniel · Wray, CON718WWilson Gregory A · Mc Alpin, FLN7190BKing Tyler Brooks · Saint Stephen, SCN7190CJets To Helis LLC DBA · Chandler, AZN7190DWard Ben N · Salcha, AKN7190GM T Machinery Inc · Porter, TXN7190JEmerald City Aircraft Leasing Inc · Port Orchard, WAN7190LYoung Anthony G · Murray, KYN7190QEhc Group LLC · Franklin Lakes, NJN7190RChristopher Ralph K · Weedsport, NYN7190WAndros Aviation LLC · Santa Margarita, CAN7190YMiller Kevin · Collegedale, TNN7191DDahlen Bear A · Eugene, ORN7191EStandard Aviation Services LLC · Farfurrias, TXN7191PRamineni Raja · Fort Mill, SCN7191UDarrow Matthew J · Truckee, CAN7191ZDunn Blake C · Bristol, CON71921Rychlik Kevin Charles · Manassas, VAN7192BAstroone LLC · Culpeper, VAN7192H7192h LLC · Redwood City, CAN7192LCheek Donald · Ocala, FLN7192PBest Equipment Leasing LLC · Bakersfield, CAN7192QMansfield Heliflight Inc · Milton, VTN7192SUniversal Technical Institute Inc · Phoenix, AZN7192URed Hawk Aviation LLC · Allegan, MIN7192WPope Larry · Lake View, NYN7192ZAce Aeromotive Inc · Miami, FLN7193DKeech Paul A · Fairbanks, AKN7193LLevison Louis · Klamath Falls, ORN7193PSzczawinski Anthony J · Elko, NVFirst renewal noticeN7193UJets To Helis LLC DBA · Chandler, AZN7193VArmbruster Jeffrey T · Norfolk, NEN7193YExcel Helicopters LLC · Orange Grove, TXN7194Ajayi Samuel O · Fredericksburg, VA
Back to AD 87-10-06 R1