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.
N5816WQin David · La Verne, CAN5817AMarceau Michelle · Spofford, NHN5817TSnow Robert I · New Caney, TXN584CMBurns Timothy R · Eighty Four, PAN597CAWest Wind Farm Inc · Camarillo, CAN597MBBrandon Air LLC · Valley Stream, NYN598BGSamuel James · College Station, TXN60GZAbl Aviation Inc Trustee · Wilmington, DEN60RPMartin Rolf M · Wellsburg, NYN611PSPc Simonton Egineering LLC · Greensboro, GAN616RLDeeb David Antony · Shelton, CTN616SMDoo Dah Inc · Wilmington, DEN6188ANash Corey · Spring, TXN61YNDonovan Thomas · Spring Hill, FLN6201FJohnson Norman E · Ellijay, GAN6201YSorenson Andrew · Pickens, SCN6227ZJet Green Aviation LLC · Terryville, CTN622DXChang Daniel H · La Crescenta, CAN63BSPfinx LLC · Chapel Hill, NCN63GMBmi Aviation LLC · Hallandale Beach, FLN641CKrause Michael R · Sugar Land, TXN644DDArfvidsson Emil · Mountain View, CAN64SZTotal Aircraft Management Inc · Acworth, GAN655FTFord Charles C · Godfrey, ILN657FTNeal Randy W · Johns Creek, GAN65EEEssler Kim L · Garrison, NDN65PMKummer Mark · Hayden, IDN6684UFowler Kenneth G · Newport, TNN66HMRegistered aircraftN672WTWhiskey Tango Aviation LLC · Jasper, GAN676RJCrawford Charles Eldridge · Eastvale, CAN68AGDelucia Dennis DBA · Franklin, PAN696GSTriple Whiskey LLC · Lubbock, TXN69DLIndy Air Sales LLC · Anderson, INN69LNValiair Limited Co Trustee · Casper, WYN700CROneglia Francis G · Hawthorne, FLN700CWDelta Sierra Aviation LLC · Wills Point, TXN700TPCreedon Robert A · Lompoc, CAN707JLCanova Frederick M · Delray Beach, FLN707LTSlater Timothy · Santa Rosa, CAN707RJSouthern Aircraft Consultancy Inc Trustee · Casper, WYN713JADesert Sealants Corp · Queen Creek, AZN716JRegistered aircraftN717BSTla Inc · Middletown, DEN7201HMcclure Richard A · Edna, TXN7201POrillac Natalie · Doral, FLN7201VCompass Rose Aviation LLC · Fort Myers, FLN7201XMathews Daniel R · Vallejo, CAN720TSSpencer David T · Dayton, OHN723LPDaly Robert · Plainview, NY
Back to AD 95-26-16 R1