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.
N9505HFinal Approach Aviation LLC · Danville, CAN9506XBradshaw Aviation Systems LLC · Bridgeton, MON9507ALott William F Jr Trustee · Oklahoma City, OKN9507BHanderson Ronald Jr Sr · Sitka, AKN9507LBatra Sanjeev · Roseville, CAN9508BRegistered aircraftN9509GMid Continent Aircraft Corp · Hayti, MON9509TKline John C · Wolcottville, INN9509XHilliard Keith B · Van, TXFirst renewal noticeN950ACRed Carpet Aviation LLC · Carlsbad, CAN950DRRjc Skyhawk LLC · Middletown, DEN950MEN950me LLC · Manassas, VAN950MGDurante Salvatore · Oro Valley, AZN950SRAcme Aero LLC · Kingman, KSN95103Shelton Aviation Inc · Christiansburg, VAN9510HRegistered aircraftN9510JOrange County Mosquito Control District · Orange, TXN9510LCivil Air Patrol Inc · Maxwell Afb, ALN9510XWillett Michael J · North Little Rock, ARN9511BRadford Kenneth J Jr · Chugiak, AKN9511RBrewer William B · Fairbanks, AKN95122Mcnamara Kevin M Jr · East Aurora, NYN9512ACook Timothy L · Oklahoma City, OKN9512HTracy Patrick J · Maddock, NDN9512XSwagerty Michael P · La Mesa, NMN9512YPalmer George J III · Orlando, FLN9513BLong Michael A · Grand Lake, CON9513GThomas David · Boise, IDN9513HHigh Flight Academy LLC · Allison Park, PAN9514GP51d Mustang LLC · Bigfork, MTN9514HFrerichs John E · Gurley, ALN95159Kinne Dagmar · Woodburn, ORN9515BGrason Aviation LLC · Appleton, WIN9515GRegistration Pending · Kenai, AKRegistration pendingN9515RCunningham Michael K · Pinebluff, NCN9515XJones Jeffrey A · Rehobeth Beach, DEN9516AHogan Robert P · North Pole, AKN9516XZeroone Easy Group Inc · Winchester, KYN9517HPlane Solutions LLC · Kalispell, MTN9517TSteele Cody T · Polson, MTN9517XKelley James E · Kennewick, WAN9518AFinney Kevin Anthony · Hawthorne, FLN9518GKomer Thomas B Jr · Woodburn, ORN9518TParks Paul E · Titusville, FLN951CEaston Robert C · Lasalle, CON951CCBrouchoud Jayson R Trustee · Ridgecrest, CAN951HCUsweixin · Sheridan, WYN9521AWadsworth Harley · Albuquerque, NMN9521HJordan Recreation Development LLC · Clinton, TNN9521XTailwynns LLC · Lake Placid, FL
Back to AD 87-20-03 R2