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.
N95606Hillsboro Aero Academy LLC · Hillsboro, ORN9560BAltair Aircraft LLC · Gainesville, FLN9560TStern Harvey W · Middletown, NYN9560VRegistration Pending · Big Spring, TXRegistration pendingN9560XSammons Richard Allen · Glen Arm, MDN95615Li LLC · Seattle, WAN9561GFlying D Aero LLC · Colorado City, TXN9561XAirxn LLC · Williams, AZN95626Smith Charles · Hays, NCN9562BCharleston Flying Club LLC · Charleston, SCN9562HL & W Aircraft Investments LLC · Homestead, FLN9562THiggs Jared E · New Boston, TXN9562VWinged Winds LLC · Douglassville, PAN9562XMclenaghan Alvin N · Phoenix, AZN95631Tree Top Partners LLC · Berea, KYN95639Barbee Donald · Columbus, OHN9563GLitzen Guide Service · Kenai, AKN9563HHartman Thomas J Trustee · Anchorage, AKN9563XGraham Raymond S · Citra, FLN95646Advantage Aviation Inc · Palo Alto, CAN95649Hawker Aviation LLC · Lewes, DEN9564HLafleur Laurence J · Natick, MAN9564TAlvarado Ruben Jr · Brownsville, TXN95650Jnl Leasing LLC · Basalt, CON95659Uccellino Inc · Roslyn Heights, NYN9565VHijazi Sakher Samir · San Clemente, CAN9565XBerkbiegler Allen L · Lonedell, MON95661Godfrey Turhan L · Lewis Center, OHN9566BQualitair LLC · MichelstadtN9566HGarcia Mario · Yuma, AZN9566LNorth Sound Aviation · Sedro Woolley, WAN9566VS D Enterprises Ltd · Brookhaven, NYN95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILN95677Steils Building Renovation And Management Inc · Lino Lakes, MNN95678Jpr Aviation LLC · Hillsdale, INN9567AProflight 1 Inc · Midland, NCN9567HCurley Mark L · Alamosa, CON9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationN95682Longview Research And Development Inc · Chetek, WIN95686Shutt Terence M · Goleta, CAN9568GTakai Hiroyasu · San Jose, CAN9568LD & S Aviation LLC · Spring, TXN9568VAnderson Zachery D · Bigfork, MTN95696Cobb Brent D · Eden Prairie, MNN9569HOsborn Larry R · Summerville, SCN9569TThomas Richard E · Lafayette, TNN9569XStepair LLC · Spring Valley, OHN956ASA2g International LLC · San Juan Capo, CAN956BFMpd2 Inc · Valdosta, GAN956ERZulu Aircraft Leasing LLC · Grants Pass, OR
Back to AD 87-20-03 R2