AD 87-20-03 R2
Registered aircraft · 54,015
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-20-03-R2')
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-20-03-R2')
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-20-03-R2') 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-20-03-R2') 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.
N988BGMojo Flight Group LLC · Gainesville, GAN988CMAvc150 LLC · Carson City, NVN988MTurecek Peter J · Fairfield, CTN988MVMiller James A · Granada Hills, CAN988PSStartz Paul D · Douglasville, GAN988PWChristiansen Bruce L · Windham, MEN9890ECivil Air Patrol Inc · Maxwell Afb, ALN9890HDe Rico Nicolas · Tracy, CAN9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9890MR & R Brown Inc · Sun Valley, IDN9890XSelman Jett · Anchorage, AKN9890YValiair Lc Trustee · Casper, WYN98913Civil Air Patrol Inc · Maxwell Afb, ALN9891GOuellette Kevin E · Frederick, OKN9891TDunkley Bret Y · Kotzebue, AKN98923Costa Flying Service Inc · Painted Post, NYN9892AMiner Jay G · Seattle, WAN9892GFritz John P · Belvidere, NJN9892MBogner Aviation LLC · Dover, DEN9892QLytle Jack J · Omaha, NEN9893HBain Aviation Inc · Weiser, IDN9893QDougherty Casey · Rock Island, WAN9894AHealdsburg Aviation · Healdsburg, CAN9894EDebski Matthew B · Belmont, CAN9894G1s6 Flying Club Inc · Sandpoint, IDN9894JKosko Stanley G · Seattle, WAN9894QKarpov Konstantin A Trustee · Fort Bragg, CAN9894YRaymond Andy · Council Bluffs, IAN98954Emerson Solutions LLC · Bellingham, WAN9895ETurnkey Aviation LLC · North Las Vegas, NVN9895GKellerman Roger B · Rockford, ILN9895QCk Leasing Services LLC · Wilmington, DEN9895VTogo Aviation Services LLC · Palmer, AKN98960Buiqui Aerospace Corp · Kissimmee, FLN9896HHilltop Aviation LLC · Rowlesburg, WVN9896JVande Berg David M · Sioux Center, IAN9896XKing Kevin J · Angle Inlet, MNN9897AAero Garage Inc · Fort Myers, FLN9897MAcme Aviation USA LLC · Nashville, TNN9897QAbove All Aviation Inc · Santa Barbara, CAN98981Airplane And Drone Flight Instruction LLC · Orlando, FLN98987Civil Air Patrol Inc · Maxwell Afb, ALN9898ELamar Rosa E · Santa Paula, CAN9898QSecond Wind Aviation Corp · Friday Harbor, WAN9898THumphress John A III · Campbellsville, KYN9899GWings Over Texas LLC · Denton, TXN9899HCrimson Aircraft Sales LLC · Tuscumbia, ALN9899QBrown Richard K · East Falmouth, MAN989CWCardinal Wings Aviation LLC · Buckner, KYN989SDFlyby Equipment LLC · Factoryville, PA
Back to AD 87-20-03 R2