AD 96-03-13
Registered aircraft · 1,042
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-03-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-03-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-03-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-03-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.
N487NNDakota Equipment LLC · Bismarck, NDN487VCOaklr LLC · New York, NYN488FTJasper Dirt LLC · Ridgeland, SCN48CSMattias Transport LLC · Tucson, AZN48CVAviation Trust Co LLC Trustee · Oklahoma City, OKN48PACbc Aviation LLC · Hayden, IDN48QDynamic Avlease Inc · Bridgewater, VAN490TXHosell Aviation LLC · Rome, GAN4925TAir Services LLC · Spokane, WAN492GPBank Of Utah Trustee · Salt Lake City, UTN494BHEvergreen Holdings LLC · Missoula, MTN499CZN499cz LLC · Milwaukee, WIN49KCBeech Transportation Inc · Eden Prairie, MNN49LLSilver Wing Aviation LLC · Wilmington, DEN49RDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN4QLFremont Motor Company Inc · Lander, WYN500CRElite Medical Air Transport LLC · El Paso, TXN500FEBeech Transportation Inc · Eden Prairie, MNN500HGEm Aviation Ka B200 LLC · Atlanta, GAN500LPMeri Acquisitions LLC · Kilgore, TXN501DUWaterside Holdings LLC · Knoxville, TNN501EBPrecision Holdings LLC · Kimberly, IDN501HKBam Aviation LLC · Baton Rouge, LAN502APJbjp Capital Holdings LLC · Newark, DEN503AWCsi Aviation Inc · Albuquerque, NMN503JMDls Aviation LLC · Gilmer, TXN503PWellsprings Aviation LLC · Winston Salem, NCN503RMKa200 LLC · Jacksonville, NCN504ECAlpha Tango LLC · Little River, SCN504GFOxford Advisory Aviation LLC · Orlando, FLN505AWCsi 135 Division LLC · Albuquerque, NMN505SPN505sp LLC · Ontario, CAN507BEM P Leasing LLC · Vermillion, MNN507GFBallard Aviation Inc · Newton, KSN5092SGreat Plains Communications LLC · Blair, NEN509FPPerdue Farms Inc · Salisbury, MDN50EDynamic Avlease Inc · Bridgewater, VAN50GGN50gg Leasing LLC · Ponca City, OKN50KGTurbo Air Charter LLC · Boise, IDN50NABv Transportation LLC · Portland, ORN50PACenterline Aviation Inc · Middletown, DEN50XDynamic Avlease Inc · Bridgewater, VAN510GSAmdel Holding LLC · Houston, TXN511DPAir Med Services LLC · Lafayette, LAN511GAGeaux Aire LLC · Savannah, GAN511TAAir Med Services LLC · Lafayette, LAN514TBFast Marketing Strategies LLC · Royal Oak, MDN519DBN519db LLC · Dover, DEN519RRCgs 2003 LLC · San Leon, TXN520DDThomas Asset Group Ltd · Springtown, TX
Back to AD 96-03-13