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.
N9630UWright Brent C · Boulder Creek, CAN9630VN275508 LLC · Margate, FLN9630WNull Robert D · Lake Charles, LAN9631BPercy Flyers LLC · Dexter, MIN9631CThompson Joseph D · Alliance, NEN9631JMckibben Andrew D · Gilmanton Iw, NHN9631MOrvin Sanden Inc · Wyndmere, NDN9631PKansas Air LLC · Linn, KSN9631QHuntsman Ferral Don · Juneau, AKN9631RBw Flying Association · Seattle, WAN9631UCross Scott · Scott Township, PAN9631VHarrold Bruce E · Greybull, WYN9632HSweitz-Air Inc · Stewartstown, PAN9632JAirbrain Aviation Inc · Snellville, GAN9632MAvimar · Marina Del Rey, CAN9633HWings Over Texas Holdings LLC · Denton, TXN9633MGould Zachary · Pleasant Hill, MON9633UMoseley Warren C · Haslet, TXN9633WFladager Enterprises Inc · Peerless, MTN96342Aircraft & Aviation Professionals LLC · Coldwater, MIN9634DBacklund Scott W · Greybull, WYN9634K137 Lynwood LLC · Elmira Heights, NYN9634MBig Sky Flying Inc · Napa, CAN9634QDubois County Flight Services Inc · Huntingburg, INN9634WShinar Philip C · California City, CAN9635BFisher Frank L · San Diego, CAN9635HArizona Aircraft Leasing LLC · Mesa, AZN9635KN9635k LLC · San Luis Obispo, CAN9635LAcme Club Training Inc · Anchorage, AKN9635MN9635m LLC · Cumming, GAN9635QRozynski Jason K · Malabar, FLN9635UCarmichael Donald L · Carlisle, INN9635V35 Victor LLC · Decatur, GAN9635WGordon David · Long Branch, NJN9636HMontanez Orlando · Guaynabo, PRN9636JPorter Julia N · Pflugerville, TXN9636KVanderwerf Stan L · Colorado Springs, CON9636LWest Main Auto Sales Inc · Tupelo, MSN9636MBistline Leland K · Fredonia, AZN9636RTrans West Specialties · Visalia, CAN9636USchroeder Wolf Udo · Rochester, NYN9636VNaperville Flying Club · Woodridge, ILN9637DSpivey Harold E · Thomaston, GAN9637KClik Services LLC · Forestdale, MAN9637QWingsleasing LLC · Wichita, KSN9638CJones Francis P Jr · Newport, ARN9638HHatbright Farm LLC · Wilmington, DEN9638JPrince Jennifer R · Farr West, UTN9638MPinheiro Rodrigo P · Albuquerque, NMN9638QPeterson John E · Benton, KS
Back to AD 87-10-06 R1