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.
N97540Popeye And Olives Adventures LLC · Helena, MTN97543Carter Michael E · Dallas, GAN97549Brandt Jeremy · Torrance, CAN9754GWings Aircraft Leasing And Services LLC · Wasilla, AKN97553Gregor Anthony J · Bethesda, OHN9755BRs Specialties LLC · Anchorage, AKN9755DSkyline Solutions Inc · Deland, FLN9755HQualitair LLC Trustee · MichelstadtN97563Fenell Jeffrey A · Stahlstown, PAN9756VLarson Lynn R · Casselton, NDN97578Utecht Thomas A · Friant, CAN97580Wardall Wesley David · Ione, CAN9758BSherwood Aviation LLC · Lewes, DEN9758HBlue Sky Aviation Association Inc · Readington, NJN9758XHernandez Luis Ignacio · Naples, FLN97596Aero-Sphere Inc · Longmont, CON9759ALove John W Jr · Los Lunas, NMN9759BHernandez Raymond · Burleson, TXN9759GMcneill Dudley · Happy, TXN9759HHavelka Glen C · Boerne, TXN9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLN975BWWeidendorf Investments LLC · Hinckley, MNN975PCBeck Steven · San Clemente, CAN975SRBrown Tyrone · Fontana, CAN97601Zapata Michael III · Cary, NCN9760AK & S Aviation Adventures LLC · Toms River, NJN9760XGubler Joseph A · Fairhaven, MAN97611Bravo Aviation Co · San Antonio, TXN9761HBrentco Aerial Patrol Inc · Canton, OHN97622Paul A Leep Md P C · Chassell, MIN97627Speer Paul B · Vancouver, WAN9762EBuermann Hank · Brookfield, VTN9762XMcdonald Daniel P · Canon City, CON97633Graham Brown Aircraft Rentals LLC · Wilmington, DEN9763ARoman Financial Inc · Monroe, WAN9763BS-3 Aero Ent LLC · Denton, TXN9763HReed Grain & Bean Inc · Buhl, IDN97640Foutz William R · Farmington, NMN9764BPowder Hound LLC · Girdwood, AKN9764GSicheneder Scott · Wasilla, AKN97650Updraft LLC · Kissimmee, FLN9765HAspen Helicopters Inc · Oxnard, CAN9765XBaer Monte Wayne · Ronan, MTN97661Gravity Productions Inc · Redondo Beach, CAN97662Northwest Alabama Holdings LLC · Spruce Pine, ALN97672You Are My Sunshine Aviation LLC · Orange, TXN97674Oc Flight Lessons LLC · Costa Mesa, CAN97678Walkinshaw Marcus D · Ridgeland, MSN9767GCottingham Dwain R · Attica, INN9767HSwanson Joseph C · Blairsville, GA
Back to AD 87-20-03 R2