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.
N90558Hagele Aviation LLC · Hillsboro, ORN9055CBison Aero LLC · Kalispell, MTN9055MVincent Flying Service Inc · Kaplan, LAN9056AGreenough Wade E · Kasilof, AKN9056MGlasscock David M · Matthews, NCN9056TMowbray Carmine Trustee · Polson, MTN9057HAmoroso Ricardo C · Powder Springs, GAN9057MUnderhill James F · Charleston, WVN9057SMedical Supply X LLC · Coats, NCN9058TJlp Equipment LLC · Anchorage, AKN9058XSouthern Skies Aviation Inc · Cedar City, UTN9059AKown William B · Hamilton, ALN9059GElevated Aviation LLC · West Plains, MON9059MMortvedt Arthur D Trustee · Manley Hot Springs, AKN9059TTwt Wings LLC · Mccall, IDN9059XHunt William E Jr · San Jose, CAN905AZN905az LLC · Miami, FLN905BWMauro William J · Lancaster, CAN905KKRdc Air LLC · Lithia, FLN905KSZoppe Eduardo · Lakewood Ranch, FLN905WAMy Way Aviation LLC · Weston, FLN9060GWalther Newell A · Wasilla, AKN9060HJ&S Flying Enterprises LLC · Zanesville, OHN9060MAshland Jeffrey C · Spirit Lake, IAN9060XLattin Travis W · Beloit, KSN9061XSmithhart James R · Normandy Park, WAN9062ASale Reported · Wasilla, AKSale reportedN9062MKissee Dale D Trustee · Chugiak, AKN9063XGregory Larry C Trustee · Farmington, MON9064GEvans Brandon Ks · Montgomery, ALN9064XCherokee Three LLC · Greensboro, NCN9064ZCarranza Matthew J · Casa Grande, AZN9065MWillecke Donald K · Punta Gorda, FLN9065TBarker Adam W · Mendota, VAN9066MHarbison Laura L · Redlands, CAN9066RForage Jean Pierre Md · Lakeway, TXN9066TVertical Investment Strategies LLC · Mesquite, NVN9066XSkyskaters LLC · Portland, ORN9067THatch Greg J · Billings, MTFirst renewal noticeN9067XN78305 LLC · Kindred, NDN9068ALucas Terry L · Oakdale, CAN9068HGundlach Mark A · Fruitland, WAN9068MShaw Brian · Granada, CON9068RHrabe Dusten · Chamberlain, SDN9068XWeinberg Jerry J · Metairie, LAN9069MGross Marlene K · Clear Lake, IAN9069XKeefer Aviation LLC · Lancaster, OHN906AZN906az LLC · Miami, FLN906KSKingsky Flight Academy LLC · Lakeland, FLN906MDFive Rivers Flight Training LLC · Livermore, CA
Back to AD 87-20-03 R2