AD 95-09-13
Registered aircraft · 1,061
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:95-09-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:95-09-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:95-09-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:95-09-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.
N414MKSky West Aviation Inc Trustee · Albuquerque, NMN414MPJackson Management Group LLC · Luverne, ALN414NCN6577juliet LLC · Canton, GAN414NSNsi Flight Services LLC · Idaho Falls, IDFirst renewal noticeN414PAPafford Emergency Medical Services Inc · Ruston, LAN414PFGo Fly Aviation LLC · Colorado Springs, CON414PG89 Galileo Aviation LLC · Estero, FLN414PHJaw A1r LLC · Chesapeake, VAN414PSN414ps LLC · Yucaipa, CAN414PWMountain Air Helicopters Inc · Dover, DEN414RB4rb LLC · Roseburg, ORN414RKAsp Aviation LLC · Macon, GAN414RWJxc Holdings LLC · Clovis, CAN414SHNichols Farms · Seminole, TXN414SMSwair LLC · Cheyenne, WYN414SPDiamond Upgrades LLC · Phoenix, AZN414TAJerry L Stephens Investments LLC · Sunset, SCN414TDAtlas Aviation LLC · Maple Grove, MNN414TFBlue Sky Aviation LLC · Columbia, TNN414TJLobair LLC · Peoria, ILN414UMSouthwest Management Group Inc · Farmington, NMN414VA7210 Charlie LLC · Atlanta, GAN414VBBank Of Utah Trustee · Salt Lake City, UTN414WEN414we LLC · Valrico, FLN414WJCenturion Flight Services Inc · Palo Alto, CAN414WKValiair Ltd Co Trustee · Casper, WYN414WRMoreno Leon Bernardo Eucario · Missouri City, TXN414WSWessex Airlines LLC · Boca Raton, FLN414WTMr Boo Properties LLC · Indianapolis, INN414WYJrh Operations LLC · Canyon, TXN414XXMcnally Operations LLC · Norfolk, NEN414YHVictory Maximus II LLC · Dublin, OHN414ZHynes Kevin P · Branson, MON4162GWillman Loren · Nevada City, CAN416RARegistration Pending · Muskegon, MIRegistration pendingN418BMOrion Aircraft Holding LLC · Rocky Mount, VAN41CUEncinal Aviation LLC · Springfield, MON41LJPic Aviation Group LLC · Cornelia, GAN41WFJack Ryan Aviation · Woodcliff Lake, NJN41WTPremiere Aviation Inc · Concord, CAN4200CEagle Point Homes LLC · Baytown, TXN420WESwv Aviation LLC · Winter Park, FLN421Aerodental Inc · Colorado Springs, CON421AGone Flyin LLC · Wilmington, DEN421AAHammett Holdings LLC · Townsend, GAN421AGFarm Flysician LLC · Ardmore, OKN421ANSunrise Properties I LLC · Bainbridge Island, WAN421APPremier Air Services Ltd · Canton, OHN421ARHlc Travel LLC · Perham, MNN421ASCrocker Seleno · Pomona, CA
Back to AD 95-09-13