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.
N9347UAirgo Inc · Centralia, ILN93488Rawareo LLC · Warsaw, MON9348AShelomis Dennis B · Shelton, CTN9348HDeshazer Bill G · Gladewater, TXN9348XWhittemore Kenneth P Jr · Fredericksburg, VAN9349MDouble R Air LLC · Miami, FLN9349RMccelvey James L · Dilley, TXN9349XDicarlo Jason M · Covington, LAN934GRGrossman Robert W · Andover, MAN934TCVandentoorn Randy J · Caledonia, MIFirst renewal noticeN934TRAris Leasing Inc · Sunnyvale, CAN9350AGalloway Thomas E S · Oklahoma City, OKN9350BHoman Ralph C · Weiser, IDN9350CCloud Dancer Inc · Berlin, MDN9351DJennings David M · Huffman, TXN9351HBrown Daniel Thomas · Layton, UTN9351UHolt James D · Greensboro, NCN9351XSasser Konnie B · Granbury, TXN93526Delta State University · Cleveland, MSN93529Richmor Aviation Inc · Hudson, NYN9352CSage Blue LLC · Yakima, WAN9352XLinhart Charles W · Dayton, WYN9353ARoelofs David M · Prescott, AZN9353DRegistration Pending · Simi Valley, CARegistration pending, canceledN9353ECivil Air Patrol Inc · Maxwell Afb, ALN9353GMisyukevich Konstantyn · Clarkston, MIN9353RStephanian Erick Trustee · Naples, FLFirst renewal noticeN9353YKovax Aviation LLC · Youngstown, OHN9354BC2 Aero LLC · Dallas, TXN9354CSmith Richard M · Stanwood, WAN93550Flight School Of Gwinnett Inc · Lawrenceville, GAN9355CGrobbelaar Warren · Naples, FLN9355NGardner Tyler J · Lowell, MEN9355RSkyline Aviation LLC · Lewistown, MTN9355XTaylor John A · Lexington, MAN9356BWard Clayton D · Mcville, NDN9356HQuad Cities Aero LLC · Bettendorf, IAN9356RQuality By Design Inc · Leesburg, FLN9356XGibson Kenneth W · Washougal, WAN9356YParsons Bruce W Trustee · Costa Mesa, CAN9357GPpp Investments LLC · Lexington, MSN9357TBonafide Investments LLC · Dover, DEN9357UBaldwin James S · Sylvania, OHN93585Sipher William M · Baker, FLN9358ELechmanski Philip J · Shelter Island, NYN9358GBig Sky Plane Holdings LLC · Kalispell, MTN9358LUnited States Air Force · Eglin Afb, FLN9358NHarvey Kandace A · Snohomish, WAN9358USaddedine Nouredine · Frisco, TXN93590G & M Aircraft Inc · Wheat Ridge, CO
Back to AD 87-20-03 R2