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.
N497WWWin Win Aviation Inc · Wake Forest, NCN500HRDese Enterprises LLC · Huntsville, ALN500KPPung Michael W DBA · Alma, MIN504KSJb522 LLC · Pflugerville, TXN50PSExecutive Airshares LLC · St Thomas, VIN515LGN515lg Holding Inc · Wilmington, DEN51KMBaker Leasing LLC · Kotzebue, AKN521PMJetset Airmotive Inc · Hialeah, FLN524AMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN524ERGrant Aviation Inc · Anchorage, AKN525SWKramme Scott R · Elmer, NJN528CHWord Jon D · Albuquerque, NMN52RCTrager Limestone LLC · Chillicothe, MON52TTMinuteman Aviation Inc · Missoula, MTN530JBAir Transport Services Inc · Tarpon Springs, FLN533YABb Aero Works Ltd · Whitehouse, OHN53MCGulf Air Aviation Inc · Wilmington, DEN53TAIndiana Paging Network Inc · La Porte, INN543133seaslal LLC · Lakeland, FLN543JCBritshaw LLC · Lansdale, PAN543SBBielder Street Aviation LLC · North Charleston, SCN545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN549JBBlue Bird Aviation LLC · Ocean City, MDN54CLAir Transport Resources · Naperville, ILN54WAWright Air Service Inc · Fairbanks, AKN554KDWestern Air International Co · Pompano Beach, FLN555FSJacko Josh E · Anchorage, AKN555GTRegistered aircraftN555JGLeia Air LLC · Wilmington, DEN555MFCloud 555 Inc · Wilmington, DEN55RPneuma Aviation LLC · New Orleans, LAN565BTGsg Aviation LLC · Fort Lauderdale, FLN56MHB S Aviation LLC · Stuart, FLN56MJBishop Ronald Daniel · Port Orange, FLN56PCValiair Lc Trustee · Casper, WYN57539Registration Pending · Meriden, CTRegistration pendingN575EHajdukovich Robert M · Fairbanks, AKN57GPFoncho Corp · San Juan, PRN596LKcc Aero LLC · Guaynabo, PRN59752Visionaire Enterprises LLC · Statesville, NCN59764Warbelows Air Ventures Inc · Fairbanks, AKN59777Sofisa Airways Corp · Coral Gables, FLN59809Lou Dell Aviation LLC · Simpsonville, SCN59826Air Arctic Inc · Fairbanks, AKN59829Warbelows Air Ventures Inc · Fairbanks, AKN59848Sanborn Map Co Inc · Colorado Springs, CON59865Mccorkle Joseph P II · Tyronza, ARN59867Cooper Keith L · Tabernash, CON59906Alpha Whiskey 2 LLC · Brandon, MSN59936Kelly Kent R · Montgomery, AL
Back to AD 96-24-13