AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N7028SSkylane LLC · Salt Lake City, UTN7028TFoster Chase · Mountain View, MON7029ELewis Stephen · Lebanon, ORN7029SWright Flyers LLC · Fayetteville, GAN7029XMuroc Joint Unified School District · North Edwards, CAN702AFTradewinds Aero Group LLC · Sarasota, FLN702BDaly Moses M · Underhill, VTN702CPCivil Air Patrol · Maxwell Afb, ALN702DEKelly William G · Cape May Ct House, NJFirst renewal noticeN702DZSkydive Fargo Inc · West Fargo, NDN702GTsiouklas Aviation Inc · Dunedin, FLN702GRAir America Flight Center LLC · Daytona Beach, FLN702HPJoplin Flyers Inc · Joplin, MOFirst renewal noticeN702LULiberty University · Lynchburg, VAN702TCSykes Gregory P · Arlington, WAFirst renewal noticeN702VPCaribbean Air Partners LLC · Winter Garden, FLN7030AStuckle Eugene A · Davenport, WAN7030FPaul William · Windfall, INN7030SAcoba Dylan Anthony · Orangevale, CAN7031MClarity Aviation LLC · Anchorage, AKN7031SBurns Randall A · Rogers, ARN7031XKeller Jeffery W · Longview, TXN70323Sky Equity LLC · Woodbury, MNN70326Triple E Farms LLC · Peculiar, MON7032ARobinson Michael D · Folkston, GAN7032QRegistration Pending · Oakwood, OHRegistration pendingN7032STamayo Ernest R · Dripping Springs, TXN7032XSmith David P · Pacific Palisades, CAN70333Northland Aircraft Sales LLC · Fairbanks, AKN7033AWalter Aviation LLC · Bradenton, FLN7033TTimm Alan W · Hettinger, NDN70340Wings Over Texas Holdings LLC · Denton, TXN70341Michels LLC · Wasilla, AKN7034GFat Tyre Flyers LLC · Moses Lake, WAN7034QTesch David P · Pardeeville, WIN70350Bigwings Ag Inc · Delavan, MNN70358Mcgugin Donald W · Anacortes, WAN7035AMcgavock Edward A · Columbus, WIN7035EMetz Kevin Michael · Richmond, UTN7035QEarly Bird Aviation LLC · Phoenix, AZN7036AMachuga James A · Davis, CAN7036UN7036u LLC · West Palm Beach, FLN70376Sawyer Gregory T · Olga, WAN70378Vertol Systems Company Inc · Destin, FLN7037GN7037g Inc · Newark, DEN7037MEissinger Joshua · Circle, MTN7037QJohnson Joe N · Smithville, TNN7037XCloose Brian D · Carlton, MNN70380Mindy Ltd LLC · Muscatine, IAN70386Johnson Ben A · Gainesboro, TN
Back to AD 79-10-14 R1