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.
N9359ABischof Timothy C · Saint Louis, MON9359BPalinsky Gary C · Au Gres, MIN9359CAero Sport Craft LLC · Havre De Grace, MDN9359GFloyds Flying Service LLC · Wathena, KSN9359HWarren Flying Club · Troy, MIN9359XNorthstar Management Inc · Clovis, CAN935CBCalifornia Baptist University · Riverside, CAN935PTTailspin Tommys Inc · Port Townsend, WAN9360BWallace Joseph R · Winchester, KYN9360RWaggener Chris E · Clyde, NCN9360UVeenker Frank C · Tygh Valley, ORN9360XReist Glenn A · Moulton, ALN9361BPazsint Joseph J · Wasilla, AKN9361CHaverly Maynard L · Renton, WAN9361GGensky LLC · Center Point, IAN9361HShatto Robin Trustee · Nipomo, CAN93621Sunrise Aviation · Ormond Beach, FLN9362AFoster Floyd W · Lyon, MSN9363AKincer Charles L · Richmond, MEN9363EClear Skies Capital LLC · Dadeville, ALN9363GPrecision Aviation LLC · Walker, MNN9364GGreen Dwayne C · Santa Rosa, CAN9364XHatfield Steven P Trustee · Clearwater, KSN9365AGuntly David A · Franksville, WIN9365BPillar Mountain Airframes LLC · Palmer, AKN9365HAugusta Aviation Inc · Agusta, GAN9365MFiglia Emanuele · Lewes, DEN9365XHallows Hc Holdings LLC · Salina, UTN9366BStoots David A · Fairbanks, AKN9366CSkydance Inc · Knoxville, TNN9366GSchnackenberg Cody B · Edgemont, SDN9366HPowell Jonathan L · Violet Hill, ARN9367DMccreery Aviation Co Inc · Mcallen, TXN9367HDeralex Airways LLC · Miami, FLN9367XLivingston Robin L · Vail, AZN93689Board Of Trustees DBA · Murphysboro, ILN9368AKimberlin Mark · Grants Pass, ORN9368CRadtke Edward P · Clarkston, WAN9368XS & D Aviation LLC · Pamplico, SCN9369CEastland Aviation Inc · Midland, TXN9369GLenape Signals LLC · Orange, CAN9369RTwark Eric James · Fort Collins, CON9369XPletcher Marvin D · Yuma, CON9369YBk Aviation Services LLC · Yorba Linda, CAN936AZN936az LLC · Miami, FLN936MBBergstrom Aircraft Inc · Pasco, WAN936YTorres Nathanael · Kissimmee, FLFirst renewal noticeN93706Drake Charles R · Claremore, OKN9370AKeltz Bennie J · Hillsdale, INN9370CQuackenbushalan B DBA · California City, CAFirst renewal notice
Back to AD 87-20-03 R2