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.
N92753Mccollum J R · Mount Pleasant, TXN92757Omegna Suzanne M · Spanaway, WAN92758Wayne Alan A · Flowery Branch, GAN92764Bernstein Jeffrey J · Swanton, MDN9276ABrandon Airways LLC · Bakersfield, CAN9276BKinberger Chris E · Louisville, KYN9277Lynn William S · Jackson, MSN92776Rivera Rivera Jose Manuel Trustee · Royal Palm Beach, FLN92777Macatawa Flyers Inc · Allegan, MIN9277ATibor W Farkas · Georgetown, TXN9277CIrwin Phillip R · Parker, CON9277HChorman Spraying LLC · Milton, DEN9277UPeters Airway LLC · Pratt, KSN92787Quade James C · Duluth, MNN92788Bas Part Sales LLC · Greeley, CON92789N5746u LLC · Dover, DEN9278AHanna Mark W II · Pendleton, INN9279XKhoury Alain W · Wills Point, TXN927MPPrebish Matthew · Heath, TXN927NBlue Sky Business Services Inc · Gardiner, NYN927TCWings Over Texas Holdings LLC · Denton, TXN9280BDreessen Steven C · Walkerton, INN9280MRiley Dean A · Friday Harbor, WAN92810Dilse Brian R · Grand Forks, NDN92814Kimbrell Tod L Jr · Itasca, TXN92815Halver Todd L Trustee · Advance, NCN92816Van Cleve G Steven · Windermere, FLN92817Millner James W Sr · Soldotna, AKN9281GRuffner Scott A · Luray, VAN9281RBmg Aviation Leasing LLC · Bloomington, INN9281UOtters Heinrich · Fredericksburg, TXN92822Roada Inc · Indio, CAN92824C182 Wv LLC · Charleston, WVN9282AWest Sheryl M · Champlin, MNN9282TCloud 9 Aviators LLC · Anchorage, AKN9282USchur David · Lavernia, TXN92836Clark Wyatt · Ione, CAN92837Staszak Sandra · Martinsville, ILN9283CFoerschler Dale · North Aurora, ILN9283GTexas Forever LLC · Denver, CON9283RAllied Sprayers Inc · Hawley, TXN92843Roehl John F Jr · Neapolis, OHN92844Smooth Sailing Flying Club Inc · Avon, INN92845Hainet Aero LLC · Wilmington, DEN92846Evans Millard D · Mobile, ALN9284BBeckley Larry · Scottsburg, INN92850Nelson Tabor K · Corona, CAN92855Falcon Flying Club · Mesa, AZN9285HOrion Aviation Aircraft LLC · Carlsbad, CAN9285XBlu Kaya LLC · Austin, TX
Back to AD 87-20-03 R2