AD 87-10-06 R1
Registered aircraft · 72,010
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-10-06-R1')
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-10-06-R1')
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-10-06-R1') 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-10-06-R1') 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.
N824PCHardee Jewell E · Keller, TXN824PGMount Olive Flight Club LLC · Mount Olive, NCN824PJDowney Joseph E · University City, MON824PKReisdorfer Mark J · La Follette, TNN824RCAquila Consulting Services LLC · Los Angeles, CAN824RVNielsen Matthew · Enterprise, ALN824SVMarsh Victor W · Tracy, CAN824SWWatts Stanley A · Woodstock, GAN824TELhr44 Aviation LLC · Honey Brook, PAN824TFRegistered aircraftN824TRLand Air Enterprises Inc · Boynton Beach, FLN824VRDodson International Parts Inc · Rantoul, KSN824WBest Start Inc · Kingman, AZN824WSHampton Roads Charter Service · Chesapeake, VAN82502Christofferson Kevin · Fruita, CON82504Pentecost Benjamin I · Puyallup, WAN82505Kunkle Christopher · Santa Ynez, CAN82508Jones Matthew B · Wasilla, AKN8250NBruce James E · Greenfield, INN8250PSedberry Jason A · Kokomo, INN8250WMorehead Leonard E · Bryan, TXN8250YStoltz Kevin · Locust Grove, GAN82518Zeafla Randall Reis · Elizabethtown, KYN8251DSwenson Roger A · Pahrump, NVN8251NLarue Jesse W · College Station, TXN8251PDefranco Ross A · Los Angeles, CAN8251SAirlife Aviation LLC · Elkridge, MDN8251VMarine Service Of Guntersville Inc · Guntersville, ALN8251WKeddis Moheb N · Fairfax, VAN82520Newman Scott W · Healdsburg, CAN82526Verbridge Gary · Williamson, NYFirst renewal noticeN8252CRoberts Dave C · Wibaux, MTN8252EMiami Flight Training LLC · Miami, FLN8252NWhiting Reed Brandon · Mesa, AZN8252PMontgomery Daniel G · Wasilla, AKN8252ZHodges Albert H Executor · Lyons, GAN82530Flowers Christopher L · Anchorage, AKN82532Smithy Grain Inc · Presho, SDN8253AArcher N8253a LLC · Orange, CTN82542Registered aircraftN82544Cronquist Korey J · Wasilla, AKN82547Jeffries Aviation LLC · Kalispell, MTN8254FStewart Rodney W · Pensacola, FLN8254JParis Air Inc · Vero Beach, FLN8254NBlum William C · Alma, NEN8254PRegistered aircraftAssigned, pending cancellationN8254RKrejci Ryan J · Sandstone, MNN8254YCrimson Aviation LLC · Helena, MTN82554Garnet Aviation LLC · Fort Worth, TXN82557Zehm Laura L · Monterey, CA
Back to AD 87-10-06 R1