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.
N718AJGranados Air LLC · West Palm Beach, FLN718BLRdm Aviation LLC · Mount Pleasant, SCN718CLBlue Sky Holdings LLC · Brule, NEN718SPCirrusly LLC · Edmond, OKN718SRLone Mountain Aircraft LLC · Springfield, OHN718TLBuildup LLC · Naples, FLFirst renewal noticeN719CSDavis Robert · Presque Isle, MEN719DCRosse Bradley E · Concord, MAN719EDWerner Thomas · Grand Island, NEN719LMPurcell Daniel G · Spotsylvania, VAN719SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN719TMInnovative Flight Systems LLC · Lewes, DEN71CVGo To Fly LLC · North Miami, FLN71GVVermeer Manufacturing Co · Pella, IAN71PEEairco LLC · Nacogdoches, TXN71PFPjf Air LLC · Farmingdale, NYN71TWThink West Investments LLC · Middletown, DEN71TZShell Less Turtle LLC · Chesterfield, MON720CDDewitt 2 LLC · Evansville, INN720CTDucksauce Transportation LLC · Boca Raton, FLN720ECEast Coast Aviation LLC · Falmouth, MEN720LTCowan Mark · Afton, WYN720PMurillo Carlos F · Pembroke Pines, FLN720RJRegistered aircraftN720TDHdt Aviation LLC · Rockford, ILN720XPrecise Aero LLC · Fort Myers, FLN721AP721ap LLC · Erie, CON721BTEv Services Inc · Destin, FLN721KWJj Aviation LLC · Dallas, TXN721VCSch Aviation Inc Trustee · SporleN721WTTurtlequest LLC · Dover, DEN722AMRuiz Michael · Marietta, GAN722BJBravo Juliett LLC · Bermuda Run, NCN722CDCirrus Sr22 11722 Inc Trustee · Wilmington, DEN722DHCirrus Design Corp · Duluth, MNN722FBHighland Trace Ascension LLC · Baton Rouge, LAN722MTValiair Lc Trustee · Casper, WYN722PBJ & D Aviation LLC · Salem, WIN722PLCirrus Design Corp · Duluth, MNN722RDR & R Aviation New Orleans LLC · New Orleans, LAN722SCSteward Christopher B Trustee · Dedham, MAN722SRLmsc LLC · Camden, DEN722VPValiair Limited Co Trustee · Casper, WYN723CPWidener Jeanette C · Snohomish, WAN723GTMiracle On Techwood LLC · Ponte Vedra Beach, FLN723HPBlue Heron Aircraft & Yacht Sales LLC · Indialantic, FLN723PLN723pl LLC · Pensacola, FLN723SDCleveland Aviation LLC · Westlake, OHN723TMCreative Estates LLC · Greenwood Village, CON724CDStrong Evan Edward · San Antonio, TX
Back to AD 2007-24-13