AD 95-26-13
Registered aircraft · 21,464
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-26-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-26-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-26-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-26-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.
N15311Johnson Darin Charles · Wells, MNN15313Beine Gilbert J · Campbellsport, WIN15316Drmm Aviation LLC · South Beloit, ILN15319Merchant Jerry J · Bogata, TXN1531JPerception Prime LLC · Beverly, MAN15320Taylormade LLC · Pharr, TXN15322Ofner Josef P · Canterbury, NHN15323Coastal Flight Inc · Tierra Verde, FLN15324Lewis Christopher Dean · Bettendorf, IAN15327Carey Nicholas Andrew · Glencoe, ILN1532JRosario Pamela Peralta · Orlando, FLN15334Shuart Bruce E · Wantage, NJN1533JTolmachoff Alex W · Rogers, TXN1533XBurkhardt Stacie M · Wasilla, AKN15343Bridger'S Hvac And Welding LLC · Milan, TNN1534JChapman Melvin Newton II · Mishawaka, INN15354Stephen Swift · Justin, TXN15355Brandvold Larry J · Fairfield, MTN15358Daffer Jon T · Edgewood, NMN15359Kobberdahl Matthew T · Maple Grove, MNN1535XSmith James E · Wilson, NCN15360Registered aircraftN15361Williams Darren M · Carthage, ILN15363Creativity Before Capital LLC · Tampa, FLN15367Labrousse Ronald E · Tidewater, ORN15372Hollingshead Terry L · Flint, MIN15373Johnson Brant T · Collinsville, OKN15374Smith William L · Supply, NCN15376Brown William D Jr · Mount Pleasant, TXN15377Johnson Matthew · Biglerville, PAN15378Ketcham Jesse E · Aguanga, CAN15379Huyler John C · Shreveport, LAN1537JYearta Philip T · Bono, ARN1537XSale Reported · Milton, FLSale reportedN15380Miller Aviation Group LLC · Coon Rapids, MNN15383Nevill Donald L · Clare, MIN15388Smith John-Michael L · Austin, TXN1538XStaton Justin · Kemah, TXN15391Lyon Anthony R · Bethesda, MDN15392Dgm Aviation LLC · Hurricane, WVN15396Nomann Arnold H · Viroqua, WIN15397Boisvert Thomas Michael · Sonoita, AZN153ASBowen Arrow Aviation Inc · Albany, NYFirst renewal noticeN153LHFarmingdale State University · Farmingdale, NYN153MKThomas Paul · Falls Church, VAN153SMN153sm LLC · Tallahassee, FLN154Nystrom Timothy L · Foreston, MNN15401Adkins Jerome B · Northridge, CAN15402Swaz Aviation LLC · Queen Creek, AZN15405Kurin Kerry · Tulsa, OK
Back to AD 95-26-13