AD 96-24-13
Registered aircraft · 689
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:96-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:96-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:96-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:96-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.
N353SLSneaker Air Inc · Miami, FLN3544MValiair Lc Trustee · Casper, WYN35475Abd Corporation Inc · Tinian, MPN3547BMlmce Company Inc · Winchester, VAN3547GCarto Flight Inc · Willoughby, OHN3548BJaa Holdings LLC · Springfield, ILN3548JCarden Kevin · Hoover, ALN35497Fox Aircraft LLC · Bethel, AKN3549XAirplane Four LLC · Miami, FLFirst renewal noticeN3555BMtwc LLC · Ithaca, NEN3555DDove Enterprises LLC · Wilmington, DEN35580Aero Charter New England Inc · Mansfield, MAN35584Aztec Worldwide Airlines Inc · Wilmington, DEN3558XAwmr LLC · Conroe, TXN355FRD Hadjidemetriou Aviation Services Corp · Wilmington, DEN356DBCaldwell Island LLC · Sherborn, MAN357SAFox Aircraft LLC · Wasilla, AKN3582PAir Arctic Inc · Fairbanks, AKN35834Carto-Flight · Willoughby, OHN35841Flyingvine LLC · Gilford, NHN3586DDurrell Lee W · Memphis, TNN3587PMsm587p LLC · Jericho, NYN35890Ja Aero LLC · Chicago, ILN3589BAir Arctic Inc · Fairbanks, AKN3589XMarc Inc · Bolton, MSN3590BTranquil Air LLC · Lighthouse Point, FLN3590DSale Reported · Xxx, OKSale reported, canceledN359CMarc Inc · Bolton, MSN359RXD-Kal Leasing LLC · Meadowbrook, WVN35RDIngersoll Grove LLC · Springfield, MAN369KJGrace Aire Inc · Corpus Christi, TXN36PBMarin Pacific International LLC · Apple Valley, CAN371MCSale Reported · Palm City, FLSale reportedN371WAAkro Attitudes Inc · Lighthouse Point, FLN3744UCristiani Sandra Elizabeth · Miami, FLN3746PSale Reported · Fort Lauderdale, FLSale reported, canceledN376DGClark Anthony · Augusta, KSN376NCLima Delta Company Trustee · New Castle, DEN378MMBento De Deus Amarildo · Margate, FLN385RMG Force Air LLC · Columbus, OHN38KCChanney Aviation Group LLC · Las Vegas, NVN38MCGulf Air Aviation · Wilmington, DEN390JDSevern Aeronautics Ltd · Annapolis, MDN396JHGoode Todd · Nampa, IDN39CACannondale Aviation L L C · Wilton, CTN39EHAir Travel Management Of Delaware LLC · Wilmington, DEN39HASmc Ltd · Somerset, WIN3VMAztec Worldwide Airlines Inc · Wilmington, DEN400CMAerial Surveys International LLC · Watkins, CON400HMBarneys Services Inc · Newton, IA
Back to AD 96-24-13