AD 2007-24-13
Registered aircraft · 4,026
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:2007-24-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-24-13')
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:2007-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-24-13') 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.
N307CPCirrus R50 LLC · Shreveport, LAN308CDM&R Transport LLC · Dover, DEN308JJjc Air LLC · Normandy Beach, NJN308LSpirit Aviation LLC · Dunedin, FLN309CACloud Niner LLC · Levittown, NYN309CDTriangle Aviation LLC · Cary, NCN309CPCirrus 497pg LLC · Scottsdale, AZN309JFRozo Matthew · Chatsworth, CAN309LSPure Pursuit LLC · Arnold, MDN309PTNelems Manufacturing LLC · Beaufort, SCN309SCCalcote Derrick · Arlington, TNN309SRWise Aviation LLC · Atlanta, GAN310ELFly Ivy LLC · Brighton, MAN310FLD & T Outlaw Properties LLC · Dallas, TXN310JFAircraft Guaranty Corp Trustee · Oklahoma City, OKN310PPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN310SATailwind LLC · Cameron, NCN310SMRegistration Pending · Pocatello, IDRegistration pendingN310TNFarfalla Aviation LLC · Santa Rosa, CAN310VPN310vp LLC · Galena, OHN3112KBeilman Charles C · Wallingford, CTN3114W865 Aviation LLC · Knoxville, TNN311AVCane Associates Aviation Consultants LLC · Mount Pleasant, SCN311KNViking Aircraft Leasing LLC · Bethel, MNN311TDWw House Inc · Lumberton, TXN312ADAltier Daniel T · Bloomfield Twp, MIN312AEN312ae LLC · Seffner, FLN312APAtish LLC · Hermosa Beach, CAN312CPSsi Mechanical LLC · San Antonio, FLN312DATspy Services Inc · Wilmington, DEN312FPEger Aviation LLC · Pittsburgh, PAN312GTKiser Consulting LLC · Atlanta, GAN312JBBadmia LLC · Polk City, IAFirst renewal noticeN312MSGulf Of America Aviation LLC · Brookshire, TXN312NGNovember Golf LLC · Shamong, NJN312PXRauschenberger Ventures LLC · Chicago, ILN312REBlue Jay Family Office LLC · Wilmington, DEN312SRStorm Consulting Enterprises LLC · Tyler, TXN313AKCirrus Design Corp · Duluth, MNN313DG3dg Aviation LLC · Louisville, KYN313LCShort Carl R · Issaquah, WAN313MHHarder-Diesslin Development Group LLC · Salida, CON313NRDawn Patrol LLC · Portsmouth, NHN313SRTrust Your Fronts LLC · Miami, OKN313TF313tf Aviation LLC · Superior, WIN313VBVernor Air LLC · Harbor Springs, MIN31416Pterosaur Holdings LLC · Scarsdale, NYN314AAlien Air LLC · Missoula, MTN314CPWilbury LLC · Las Vegas, NVN314DSFlyers Unlimited LLC · Tucson, AZ
Back to AD 2007-24-13