AD 75-12-08
Registered aircraft · 949
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:75-12-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-08')
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:75-12-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-08') 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.
N15113Life Cycle Balloon Adventures Ltd · Boulder, COFirst renewal noticeN1511BSkywalker Balloon Co LLC · Tallahassee, FLN1511MTeis Kristine J · Candler, NCN1511SPatton Janet · Denton, TXN1511YWildung Michael P · Newton, IAN1512ABartsch Sally L · Panguitch, UTN1512MAdler David M · Yuma, AZN1512NClemons Pamela K · Boone, IAN1513FBart Francis A · Old Town, FLN1514CWolfson Alan B · Loveland, OHN1514GCompton Preston W · Kingsport, TNN1514WRodrigue James N · Lewiston, MEN15157Lafountain Donald A · Florence, MAN1515EDavis Kevin J · Battle Creek, MIN1515YDurr Dean · Waynesboro, MSN15162Dekoevend Gery · Fort Garland, CON15163Broadstone Ryan · Omaha, NEN15164Weatherproof Montana LLC · Missoula, MTN1516FHansen Dustin K · Winamac, INN1516KWhitford L Chandler · Wellsville, NYN1516TMeteyer Richard L · Davisburg, MIN1517LBalloons Of Hunterdon LLC · Ringoes, NJN1517RBalloons Over Iowa Ltd · Carlisle, IAN1517VLewis John R · Leakey, TXN1518FHollenbach Darby T · Raleigh, NCN1518LAir Mo Sports · Orchard Lake, MIN15193De Koevend Enterprises Inc · Fort Garland, CON1519AWarner Donald R Jr · Edinburg, VAN1519JPhillips David L · Commerce City, CON1519MJudge Michael Jerrod · Downingtown, PAN151DWSharpee Thomas R · Brandon, SDN15209Moormann Richard C · Norfolk, VAN1520COshields Derrick W · Pickens, SCN1520LParmley Tina · Sun City, AZN1520NGlaizer Kevin D · Winchester, MAN1521AFerguson Kenneth A · Albuquerque, NMN1521GDekoevend Enterprises · Fort Garland, CON1521LLynch David B · Winchester, CAN1521WMcnabb Donald I · St Louis, MON1522HFleck Jonathan · Whitehouse Station, NJN1522PParmley Tina · Sun City, AZN1522UGarrison Susan K · San Marcos, TXN1523DDonahue Kathryn · Grove, OKN1523GSale Reported · Marlton, NJSale reportedN1523HCearley Jamey · New Durham, NHN1523KBrady Neal L · Centralia, MON1523LLeonard Ian Q · Burlington, NCN15245Rocky Mountain Balloon Adventures LLC · Pagosa Springs, CON1524RCity Of Riverton · Riverton, WYN1524UGoodman Travis W · Amarillo, TX
Back to AD 75-12-08