AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N8252NWhiting Reed Brandon · Mesa, AZN8252PMontgomery Daniel G · Wasilla, AKN8252ZHodges Albert H Executor · Lyons, GAN82530Flowers Christopher L · Anchorage, AKN8253AArcher N8253a LLC · Orange, CTN8253GHudson Allen N · Bowling Green, KYN82542Registered aircraftN82544Cronquist Korey J · Wasilla, AKN82547Jeffries Aviation LLC · Kalispell, MTN82549Airgo Incorporated · Centralia, ILN8254EPerfect Agreements Leasing · Trabucco Canyon, CAN8254FStewart Rodney W · Pensacola, FLN8254JParis Air Inc · Vero Beach, FLN8254NBlum William C · Alma, NEN8254PRegistered aircraftAssigned, pending cancellationN8254YCrimson Aviation LLC · Helena, MTN82554Garnet Aviation LLC · Fort Worth, TXN82557Zehm Laura L · Monterey, CAN8255GCentral Virginia Aviation Inc · North Dinwiddie, VAN8255JBerkshire Aviation Enterprises LLC · Great Barrington, MAN8255MPhoenix Wings LLC · Oakland, FLN8255PKanooth Michael L · Washougal, WAN8255WReed Emerson E · Winter Haven, FLN82563Registered aircraftN82566Low James E · Fairbanks, AKN8256EWilliams Evan H · Sebastopol, CAN8256LNordbye Newell H · Eden Prairie, MNN8256PHouse Terry J · Mountain View, ARN8256VZ-Tech Research LLC · Greenville, TXN8256WInland Northwest Flyers LLC · Spokane Vly, WAN8256XSkyriders Inc · Pocatello, IDN8256YPhill-Air Inc · Dover, DEN82575Rocky Gary B · Campbell, TXN82577Sale Reported · Wasilla, AKSale reportedN8257ETv Air LLC · Raleigh, NCN8257GDraco Flight School Inc · Chino, CAN8257JGruber Larry E · Delphi, INN8257PWipf Ryan C · Mound, MNN8257WHou Barry · San Marino, CAN8258JKenyon Travis · Phoenix, AZN8258LWiesner Loren A Jr · Cameron, WIN8258NK&G Transit LLC · Fort Mc Coy, FLN8258WWirkus Branden D · Apo, AEN8258YJohnson David C · Chisago City, MNN82591Cornia Mike D · Wasilla, AKN82598Foothill Aviation LLC · Iliamna, AKN8259BDunn Patrick E · Marthasville, MON8259GCappello Dave Allen · Cottonwood, CAN8259NAughenbaugh Timothy A · Iriquois, SDN8259TNsa Ops LLC · Kahului, HI
Back to AD 81-18-04 R2