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.
N919BBAf Land Ventures LLC · Palm City, FLN91BPF3 Aviation LLC · Summerville, SCN91PWAerial Imaging Inc · South Bend, INN9218YHubble Boeing Development Corp · Gallipolis, OHN9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLN926HBAwmr LLC · Conroe, TXN92BLIsland Birds Inc · St Thomas, VIN931SAMarc Inc · Bolton, MSN937TTPlanemarketing LLC · Vero Beach, FLFirst renewal noticeN938PMD & B Aviation LLC · Stroudsburg, PAN942EAngry Manx LLC · Riverside, CAN948MTTrasko Mark S · Boulder, CON949WAP S S Air Inc · Middlesboro, KYN94JMRegistration Pending · College Station, TXRegistration pendingN950CTJack Of Queens LLC · Afton, OKN95KAAirborne Resources Inc · Midlothian, TXN95TCMmec Air LLC · Oxford, MSN961PAThiel Bros Roofing Inc · Sidney, MTFirst renewal noticeN96342Aircraft & Aviation Professionals LLC · Coldwater, MIN9680TK And K Recycling Inc · Fairbanks, AKN970PSKrech Greg Trustee · Huron, SDN974CSMcgregor Daniel A · Denali Natl Park, AKN979SPGulf South Services LLC · Chipley, FLN97MADodson International Parts Inc · Rantoul, KSN982KAircraft Guaranty Corp Trustee · Oklahoma City, OKN9901Noiw Resources LLC · Belle Chasse, LAN990LRDavis Aviation Inc · Brandon, MSN993HRObxpress LLC · Frisco, NCN9942GQualitair LLC Trustee · MichelstadtN995AKLake Clark Air Inc · Port Alsworth, AKN998LMArmstrong Airlines Inc · Dover, DEN9993RCsc Delaware Trust Co Trustee · Wilmington, DEN999GKTaylor Craig E · Nantucket, MAN99EGGrant Gerald F Trustee · Maplewood, MNN99TBHadden Banjamin D · Incline Village, NVN99VATwin Otter International Ltd · Las Vegas, NVN9FWWright Air Service Inc · Fairbanks, AKN9QExecutive Express LLC · Elizabeth City, NCN9TXRegistration Pending · San Ysidro, CARegistration pending, canceled
Back to AD 96-24-13