AD 75-23-07
Registered aircraft · 827
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-23-07')
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-23-07')
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-23-07') 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-23-07') 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.
N240RATop Aircraft Leasing LLC · Wilmington, DEN240RCIntegrity Sales And Auction LLC · Merrill, WIN240SQMigster LLC · Miami, FLN245BMBen-Hur Air Chariots LLC · Fort Myers, FLN24KMNorthern Jet Inc · Iron Mountain, MIN24PMHaven Harmony LLC · Sheridan, WYN252DLPlac Holdings LLC · Paradise, TXN254CMGatewood Crisp · Tifton, GAN257JDAntonini Vittorio · New York, NYN25LPBer Aviation Inc · Saratoga, CAN2631SAsplundh Eric P · Bryn Athyn, PAN2632BHeubeck Associates Inc · New York, NYN2634KKoeppel Steven Lynn Trustee · Mckinney, TXN26355Fay Andrew T · San Marcos, TXN2635XN2635x LLC · Eau Claire, WIN26370Gv Air Inc · Medford, ORN2637DMcanulla Robert · Trabuco Canyon, CAN2638XSoftware 2000 Inc · Arroyo Grande, CAN2638YLawson Sean E · Lexington, KYN2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeN2641PChandler David G · Phoenix, AZN2641ZTfs Air LLC · Loveland, CON2642ACronin LLC · Jacksonville, FLN2642YStallings Ted W · Seldovia, AKN2643YCompany Plane LLC · Wisconsin Rapids, WIN2643ZPolizzi Christopher I · Peachtree City, GAN2644VCrosby David · Potomac, MDN2664Lcj Holdings LLC · Youngsville, LAN26692Fields Douglas P Jr · Brooklyn, NYN2738BSonrise Aviation LLC · Portland, INN2740TKraybill Paul D · Portola Valley, CAN27KCLaperle Brian · Colebrook, NHN28409Gilmore Sherry · Sallisaw, OKN28849Roonie Inc · Wilmington, DEN28NTHammock Flying Service Inc · Black Rock, ARN2971QOn The Beam Aviation Inc · Hampton, GAN2MBAlfa Foxtrot LLC · Statesville, NCN2YEAllied Moulded Products Inc · Bryan, OHN300BDAircraft Inc · White Bear Lake, MNN300EB4031 Pilots LLC · Crown Point, INN300EJPartwin LLC · Greenwich, CTN300PM300pm LLC · Bloomington, INN301DBDon Davis Aviation Inc · Henderson, KYN302MCB & G Ventures LLC · Kalispell, MTN308CFBaba Kenneth D · Sierra Vista, AZN30ETZaldivar Carlos · Miami, FLN30HCKinetic Concepts LLC · Pensacola, FLN30LPDialysis Clinic Inc · Nashville, TNN30RWSaltzy Seas LLC · Loxahatchee, FLN3101TMission Air LLC · Charlotte, NC
Back to AD 75-23-07