AD 95-26-16 R1
Registered aircraft · 1,406
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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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.
N5778CTieman Matthew · Chapel Hill, NCN5779YMetz Timothy G · Chattanooga, TNN5780YShields Thomas J · Port Orange, FLN5785MCanon James P · Calumet, OKN5785TLos Alamos Aero Services LLC · Los Alamos, NMN5786ZCampagnone Robert P · Columbia, CTFirst renewal noticeN5788YWright Brent Alan · Colleyville, TXN5789SSierra Aero Corp · Totowa, NJN5795DQualitair LLC Trustee · MichelstadtN57986Registered aircraftN58016Budley Ltd · Muskegon, MIN5801CFly-A-Way Leasing Corp · Farmington Hills, MIN5801NN5801n LLC · Lewes, DEN58060Pacer Flying Club Inc · Millbrae, CAN58062Des Moines Flying Club LLC · Indianola, IAN58065Smith Richard Trustee · Dublin, CAN58079Byrne David P · Ojai, CAN5807SFisher Gary C · Louisburg, KSN5807TRoyal Treatment Carriers Inc · San Antonio, TXN58086Omg Aviation LLC · Benton, KSN5808APas Services LLC · Townsend, DEN5808PWatson James Christopher · Boerne, TXN58097Avinash M Mondkar Md Mc · Payson, AZN5809HN5809h Aviation LLC · Kalispell, MTN58102Laperle George M · Santa Barbara, CAN58103Registered aircraftN58105Mooney Skies Unlimited LLC · Merritt Island, FLN58107Perez Jeremiah · Fort Worth, TXN5811CSon Of A Gun Aviation LLC · Cherry Hill, NJN58120Air Giblinski LLC · Sedgwick, KSN5812TRegistered aircraftN58135Petticrew Travis R · Mckinney, TXN5813FGalligan Derek · Portland, ORN5813UStackhouse Thomas G · Bethlehem, PAN58143Sustich Steven R · Odessa, TXN58144Low Daniel A · Los Angeles, CAN58148Wilkerson James · Howell, MIN5814QKlapper Robert D · San Jose, CAN5814TMulligan Shawn Patrick · Santa Rosa, CAN5814YSarshad Todd · San Pablo, CAN58153Marsan Steve R · Sisters, ORN58156Kim Seuk · Springfield, VAN58158Austin Mooney Flyers LLC · Austin, TXN58159Mcclure Jeffrey S · Loomis, CAN5815CFrogmore Flyers LLC · St Helena Is, SCN5815SClear Aire LLC · Las Vegas, NVN5815XMorozov Nikolai · Tucson, AZN58162Link Stanley C · Theodosia, MON58166Harrie Michael Raymond · Marsing, IDN5816TCrossroad Productions LLC · Covington, LA
Back to AD 95-26-16 R1