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.
N9659HJd Griffin LLC · Wilmington, DEN9659QMacrafic Bruce A · Garden City, MNN9659VAitken Lyle W · Tuscaloosa, ALN965AAWings Over Texas Holdings LLC · Denton, TXN965MMBastian Devan · Vernal, UTN965MSMt San Antonio College · Walnut, CAN965SCoverdale Mark E · Folsom, CAN96602Hofer Galen J · Denver, CON96607Bailey Joe D · Trophy Club, TXN9660BHenry Lawrence D · Lohman, MON9660HCdb Group Holdings LLC · Sheridan, WYN9660XDodson International Parts Inc · Rantoul, KSN96616Air Transport Inc DBA · Las Vegas, NVN9661BKennemer Vaughn · Carter, OKN9661GAvco Patrol LLC · Lyndon, KSN9661TSiebe James E · Moscow, IDN9661XMangan Communications Inc · Bastrop, TXN96621D Gordon Aviation Inc · La Jolla, CAN96626Wingsleasing LLC · Wichita, KSN96628Bobby Nelson Aviation LLC · Kettering, OHN9662QHomiller Robert S · Bear, DEN9662VLevel X Aviation LLC · Royal Palm Beach, FLN9662XMacdonald Kaitlyn A · Dillon, MTN96634Standefer Wayne B · Highland Village, TXN96639Ringel John S · Long Beach, CAN96642Bingham Ned R · Redmond, WAN9664KUsda Aphis Ppq · Edinburg, TXN9664TKalebaugh Todd C · Lostine, ORN96654Mcgahey Timothy P · Mccall, IDN9665BMilligan Reid D · Catawba, NCN9665HDouble Bridges Aviation LLC · Enterprise, ALN9665QAlldredge Aviation · Auburn, WAN9665TFlight Tech Inc · Arlington, WAN9665VAircraftsmen LLC · Heber City, UTN9665XBarclay Richard W · Elbert, CON96665Sharp Darren · Greeley, CON96668Hollister Flying Club · Tulare, CAN9666GDl Elk Outfitters Inc · Cascade, MTN9666HMorton Tamera L · Belpre, OHN9666VMedia Stew LLC · Carson City, NVN96673Seaton Bradley G · Rio Verde, AZN96679Jacobi Joseph L · Mexico, MON9667VWilliams Burla L · New Cumberland, WVN9667XBoschee Gary L · North Fort Myers, FLN96683Otter Wings Inc · Evansville, WIN9668TSevier Brady · Ronan, MTN9668VMurphy David J · Humble, TXN9669QAce Flight Center Inc · St Thomas, VIN9669XThc Aero LLC · Boise, IDN966MTInternational Air Services Inc Trustee · Carson City, NV
Back to AD 87-20-03 R2