AD 94-20-04 R2
Registered aircraft · 4,469
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:94-20-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:94-20-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:94-20-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:94-20-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.
N35HVProdigy Aviation LLC · Port Orange, FLN35JSkybound Shenanigans LLC · Dubuque, IAN35JGJalu Financial Corp · Gray, GAN35JWN35jw LLC · Enid, OKN35KAHacker Timothy J · Pangburn, ARN35KJBunn John Timothy · Winter Garden, FLN35KWCoy Walter Thomas · Titusville, FLN35LELyall Enterprises Inc · Pauma Valley, CAN35LFPlane Fun Inc Tr Trustee · Snellville, GAN35LGAnderson Charles · Bakersfield, CAN35LVDelta Fox Aviation LLC · Fort Worth, TXN35MSimmons Dennis L · Wichita, KSN35MASidetrack Investments LLC · Flower Mound, TXN35MFFlying Barefoot Ranch LLC · Wilmington, DEN35MSHazeltine Hugh J · Saint Petersburg, FLN35MTToft Michael O · Brock, TXN35MVWeaver Kibwe · Kalamazoo, MIN35MXMontanez George O · Mesa, AZN35NBBert John Boyd III · Vero Beach, FLN35NYPerry Charles E · Aldie, VAN35QTReady Aim Flyer LLC · New Castle, DEN35RBBarnes Roger A · Cheyenne, WYN35RCG5 Aviation Inc · Englewood, CON35REDakota Aero Inc · Steamboat Springs, CON35SHulteen Grant S · Tumwater, WAN35SCCramp Steven J · Cleveland, TXN35STHess Hendrix · New York, NYN35TBCencalcom Inc · Santa Barbara, CAN35TJBeech D9462 LLC · Perry, OHN35TPMccallister Mark A · Qulin, MON35TTJ B & B LLC · Midwest City, OKN35TWRice Timothy J · Anchorage, AKN35UKInternational Air Services Inc Trustee · Carson City, NVN35UPBarker Terry · Purvis, MSN35VBEquipment Lessors Inc · Lake Hawatha, NJN35VEMckibben Howard Stephens · Elk Grove, CAN35VSRcp3 Enterprises LLC · Chesterfield, MON35WFWashburn Robert D · Newbury Park, CAN35WKSchnell Thomas · Iowa City, IAN35WVN35wv LLC · Charleston, WVN35XFCaudle David William · Arlington, TXN35XLWilliams James R · Scotts Valley, CAN35YRTonini Farm And Cattle Co · San Luis Obispo, CAN35YTArmstrong Samuel V · Lovelock, NVN3601BMiller William M · Albuquerque, NMN360BGregs Inc · Tiburon, CAN360TThroop Greg J · Spokane, WAN361Anderson G Drew · Kent, WAN3627AHint Mart H · Peachtree City, GAN3629ADarrow Mark A Trustee · Mukilteo, WA
Back to AD 94-20-04 R2