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.
N205RJBrickey Thomas J · Loveland, OHN205RLAlcott Thomas J · Jacksonville, ILN205RSGansta Of Love LLC · Moorpark, CAN205RWGarratt Tyler Trustee · Carlsbad, CAN205SJudson Alexander · Hermitage, TNN205SERecreation Activity Club Inc · Bloomfield Hills, MIN205SSAir Turbo LLC · White, GAN205TGLe Garrec Jean-Dominique M · Pittsburgh, PAN205UGoro Sky Aircraft LLC · Lino Lakes, MNN205UUTailwind Blue LLC · Lakewood, CON205VVAawca Wings LLC · Augusta, MIN20JXWorld Wide Air & Sea Inc · Wilton, NHN20PWWingnuts Aviation Inc · Franklin, INN210RHJeremiahs International Trading Co Inc · Saint Petersburg, FLN210WECross Services LLC · Wilmington, DEN211PDCaylor David Lynn · Newnan, GAN211ZNAllen Michael J · Rescue, CAN212JHHunter James A · Elizabeth City, NCN2131ESchuman William C II · Poplar Grove, ILN213CSAeromarine Airways Inc · Miami, FLN2146XGalloway Robert L III · Cypress, TXN2148CLarsen Timothy · Marietta, GAN214JC214 Mooney LLC · Boca Raton, FLN2155PRegistered aircraftN217RWBlue Skies Flying LLC · Morganville, NJN21EM2fly-Safety LLC · Azle, TXN2201Decou Gordon C · Myakka City, FLN2201AJulius Air LLC · Lewes, DEN2201MSteck Richard E · Arlington Heights, ILN2201PRm Stoudt Inc · Jamestown, NDN2201QBocaj Air LLC · Irving, TXN2201RMize Helicopter LLC · Grand Prairie, TXN220FCRegistered aircraftN220TMMoore Wistar III · Savannah, GAN2210WGarg Ken M · Brewster, NYN221FCWest Charles E Jr · Yulee, FLN222BHLudwigson Joel R · Inver Grove, MNN222KRSharon Carl G · Brookshire, TXN223FCKimzey Edwin D Jr · La Jolla, CAN226RLAircraft Guaranty Corp Trustee · Oklahoma City, OKN228ALRacach Air LLC · Corvallis, MTN22RJSandhu Balraj S · Fairfield, CAN232JTBlezek Kent D · Tustin, CAN234BPYoung Tim M Trustee · Edmond, OKN239SWPyles William J · Pismo Beach, CAN23MDBell William P · Gainesville, GAN241RCReynolds Thomas H · Toms River, NJN242CBHarte Mike · Lone Star, TXN242CPBeste Robert K · Sauk Centre, MNN242HMWes Vance LLC · Four Oaks, NC
Back to AD 95-26-16 R1