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.
N9623VSchreder Peter T · Joseph, ORN9624EA & I Aviator Investments LLC · La Habra, CAN9625QMars Aerospace Inc · Bay Shore, NYN9625VFlight Time Builders Inc · Memphis, TNN9626BAirgo Inc · Centralia, ILN9626GFly 2 Crp LLC · Cleveland, TXN9626HRenfro Jacqueline L · Bethel, AKN9626QChambers Matthew A · Tehachapi, CAN9626XPortman Joe · Elmendorf, TXN9627HSuperbuyer Inc · San Jose, CAN9627XW J Bolton Farms LLC · Marked Tree, ARN9628BBryan Kirk J · Big Timber, MTN9628GNicols Bruce D · Titusville, PAN9628HT3 Aerosports LLC · Vian, OKN96299Djm Aviation LLC · Rhome, TXN9629BVisser Ag Inc · Rigby, IDN9629GSchmitt Rudy · Brookshire, TXN9629TBramlett Russell · Winder, GAN962AFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN962AMInternational Air Services Inc · Carson City, NVN962RGBoucher John C · Lakeside, AZN962SHObermeier Scott D · Manchester, CTN9630QKelley Aircraft LLC · Weyers Cave, VAN9630TBridgford Bruce H · Anaheim, CAN9630VN275508 LLC · Margate, FLN9630XSea-S-Ta Aviation LLC · Alexandria, VAN9631BPercy Flyers LLC · Dexter, MIN9631QHuntsman Ferral Don · Juneau, AKN9631VHarrold Bruce E · Greybull, WYN9632BDbstd LLC · Nickerson, NEN9632HSweitz-Air Inc · Stewartstown, PAN9632ZAngelone Inc · Elkhart, INN9633HWings Over Texas Holdings LLC · Denton, TXN9633XCivil Air Patrol Inc · Maxwell Afb, ALN9634QDubois County Flight Services Inc · Huntingburg, INN9634XScoggin Gerald William III · Port Saint Lucie, FLN9635BFisher Frank L · San Diego, CAN9635CAirmans Aviation Co Ltd · Fort Smith, ARN9635HArizona Aircraft Leasing LLC · Mesa, AZN9635LAcme Club Training Inc · Anchorage, AKN9635QRozynski Jason K · Malabar, FLN9635V35 Victor LLC · Decatur, GAN9636HMontanez Orlando · Guaynabo, PRN9636VNaperville Flying Club · Woodridge, ILN9636YCarranza Chris J · Stanfield, AZN9637QWingsleasing LLC · Wichita, KSN9637VAllen Linda M · Amarillo, TXN9637XCypress Peak LLC · Pickens, MSN9638HHatbright Farm LLC · Wilmington, DEN9638QPeterson John E · Benton, KS
Back to AD 87-20-03 R2