AD 94-05-05 R1
Registered aircraft · 26,232
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-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N704VUBlue Raven Aviation LLC · Anderson, SCN704VYPiryk Christopher M · Ocklawaha, FLN704WBEyster Christian Charles · Sweetwater, TNN704WCLegacy Pilot Training LLC · Annandale, MNN704WDMcdonald David R · Duluth, MNN704WFFoxtrot Flight Training LLC · Berrien Springs, MIN704WHEvanson Scot A · Monroe, TNN704WNN704wn LLC · Panama City, FLN704WRGroves Malcolm Duane · Spring Hill, FLN704WTRodriguez Oswaldo · Tifton, GAN704WUWalker James O · Lovell, WYN704WWLay Lawrence W · Douglass, KSN704XBSivert Leslie A · Richmond, VAN704XGByrne Matthew · West Allis, WIN704XLWelch Donald E · Crown Point, INN704XNStiefer Charlie C · Durant, OKN704XSBrian Edward L · La Vergne, TNN704XVButzer Jeffrey D · Warrens, WIN704XXSaumer Steven E · Pine City, MNN704XYWalter Bryce D · Macomb, ILN704YASky West Aviation Inc Trustee · Albuquerque, NMN704YEMarshall J B · Talbott, TNN704YLCraig Jason · Upland, CAN704YPFoss Kayla R · Anchorage, AKN704YRB2w Corporation · Winona, MNN704YSRepke Robert · Gainesville, GAN704YVHallmark University Inc · San Antonio, TXN704YWKummer Michael J · Floyds Knobs, INN704YXMock Joseph R · Huntsville, TXN704ZDHayward Stephen L · Amarillo, TXN704ZEPlane Junkies LLC · Dover, DEN704ZHHouse Robert E Jr · Sanford, NCN704ZPErickson Elisabeth R · Port Townsend, WAN704ZRLikens Michael K · Labelle, FLN704ZUWood Donald R · Cottondale, ALN704ZWOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN70501Rosman Jerod A Jr · Manns Harbor, NCN70507Benninger Timothy A · Cobleskill, NYN7050AMccollum Devin S · Flagstaff, AZN7050MCassill Aircraft Leasing · Cedar Rapids, IAN7050SGrizzle Jason · Roscoe, TXN70510Albertson James M · Westville, FLFirst renewal noticeN7051EKuskie Charles R · Chadron, NEN7051MForrest Trevor G · Moorpark, CAN7051TWeems James M · Paris, TXN7051XBobka Christian · Apple Valley, MNN70527Hawthorn Transportation LLC · North Sioux City, SDN7052ESchmidt Jerry D · Spur, TXN7052THurst Jon M · Paw Paw, MIN70532Landmark Aerial LLC · Metuchen, NJ
Back to AD 94-05-05 R1