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.
N5265ETree Top Flying Service Inc · Clarksville, TNN5265QCohan John K · Marina, CAN5265RMoss Hill Airport Inc · Kinston, NCN52660Yancey Steven Hunter · Helenwood, TNN52662Aston Stuart A · New Braunfels, TXN52663Registration Pending · Cedar Key, FLRegistration pendingN52667Noe Daniel P · Pittsburgh, PAN52669F Sharp Aviation LLC · New Baltimore, MIN5266DColemanation Investments LLC · Naperville, ILN5266ENatchez Flight Training LLC · Natchez, MSN5266KCorsicana Aviation Training Services LLC · Corsicana, TXN5266UN5266u LLC · Brookfield, ILN52671Carver Aero LLC · Muscatine, IAN52674Miller Glenn E Trustee · Albany, ORN52677Spencer Joseph T Jr · Felton, CAN52678Land And Sea Aviation Alaska LLC · Anchorage, AKN5267EBrudelie Alan C · Lewisville, MNN5267FColeman Timothy James · Cornwall On Hudson, NYN5267HNichani Nikhil Deepak · Livingston, NJN5267QGibson Aviation Services LLC · Hudson, WIN5267RCastlegate Corp · Monee, ILFirst renewal noticeN5267VN5267v LLC · Northbrook, ILN5267YCkb Management LLC · Fayetteville, ARN52680Harris John Q · Tucson, AZN52681Clough Robert · Woodinville, WAN52683Cobb John Mark · Fayetteville, TNN52684Altair Advanced Industries Inc · Bellingham, WAN52685Glidewell Aviation Inc · Parkland, FLN52687Abby Enterprises LLC · Plantsville, CTN52689Dyberg Mike DBA · Mount Vernon, WAN5268FVincennes University · Indianapolis, INN5268HGrander Aviation LLC · Panama City Beach, FLN5268JReach For Skies LLC · San Antonio, TXN5268KSorbi Aviation Inc · El Cajon, CAN5268RJohnson Steven D · Oklahoma City, OKN52694Sullivan Michael E Trustee · Granite Bay, CAN52695Farley Ryan P · Cumberland, RIN52696Sladko Jeffrey · Battle Ground, WAN52698Marshall Gregory · Farmington, MEN5269DGeorges Aviation Services Inc · Honolulu, HIN5269ERocky Pointe Logistics LLC · Hayden, IDN5269NHigh Maintenance Inc · San Luis Obispo, CAN526BBBrookover James R · Hartville, OHN526BLWarren Flying Club Inc · Troy, MIN526EPEpic Aviation Inc · Denison, TXN526ERLong Island Aviators LLC · Seaford, NYN526FRoush Heith · Cabot, ARN526LKKenzy 2022 LLC · Castle Rock, CON526LTCheatum Roger K · Port Orange, FLN526MPS Brown Inc · Durant, OK
Back to AD 79-10-14 R1