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.
N8698NUnder Bridge LLC · Wilmington, DEN8699Blake Rodney · Trophy Club, TXN8699DBohannon James A III · Waller, TXN8699NHolding Short LLC · Travelers Rest, SCN8699PKroll Corey · Gilbert, SCN869BCInter American University Of Puerto Rico · Bayamon, PRN869CPExecutive Flight Institute LLC · Murrieta, CAN869GAtp Aircraft 9 LLC · Wilmington, DEN869KF3 Aero LLC · New Lenox, ILFirst renewal noticeN869RVThwaits John Drew · Ashland, MAN869TASheeptick LLC · Conrad, MTN869TTDimond Joan M · Birch Run, MIN869VLVieques Air Link Inc · Vieques, PRN869WCSchofield Wayne D · Polson, MTN86AJMullins Mark C · Riverside, CAN86AKBuss Bryce D · Homer, AKN86AT86at LLC · Elizabethtown, PAN86AVPlane Fun Inc Tr Trustee · Snellville, GAN86AYN86ay LLC · Burke, VAN86BJWings Over Texas Holdings LLC · Denton, TXN86BKBlue Raven Air LLC · Eagle River, AKN86BPMiller Jacob Gordon · Fountaintown, INN86BTTaylor Paul E · Hilo, HIN86CAInternational Air Services Inc Trustee · Carson City, NVN86CKFord Darin E · Colorado Springs, CON86CMNewman Aviation Services Inc · Tiffin, OHN86DPerry Richard Kevin · Titusville, FLN86DBMchugh John J · Camano Island, WAN86DJJakusz Donald G · Coppell, TXN86DMShine Dylan Patrick · Jupiter, FLN86DWWhidbey Flight Services LLC · Coupeville, WAN86ECParisi Mario · Grosse Ile, MIN86EFCic Aviation LLC · Wenatchee, WAN86FGGrantham George F · Bush, LAN86FPGateway Flight Center LLC · Port Lavaca, TXN86GMMcguire Michael D · Lake Stevens, WAN86GPNichols Clint T · Tehachapi, CAN86HCN86hc LLC · Rochelle, ILN86HFSkillman Michael W · Brookshire, TXN86HLGalpin Henry M · Kalispell, MTN86HWWalker James J · Santa Clara, CAN86HYBock Roger · Williamsville, ILN86JDBurton Nicholas D · Clinton, TNN86JJFelda Farms LLC · Felda, FLN86KYMartin Jay L · Tijeras, NMN86LGEast High Flying Inc · Othello, WAN86LKKoinzan Flying Serv Inc · Elgin, NEN86MDLol Splash LLC · Helena, MTN86MKStinson Jeffrey S · The Villages, FLN86MLLam Aviation Inc · Los Altos Hills, CA
Back to AD 87-10-06 R1