AD 75-09-13
Registered aircraft · 4,787
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-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:75-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:75-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:75-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.
N5252ALong Harold M · Carson City, NVN5255CMcintosh Law Corp · Long Beach, CAFirst renewal noticeN5256JKamenz Donald R · Mocksville, NCN5258ABeta Aviation L L C · Lewes, DEN525JRPj Flyer LLC · Avondale, AZN525KWFuller Thomas R · Scottsdale, AZN525SFPrimrose LLC · Columbus, NEN5260AN5260a LLC · Los Angeles, CAN5261JAc67333 Inc · Wilmington, DEN5263VMccullough James M · Monte Vista, CON5264CCullum Transportation LLC · North Charleston, SCN5264JBrowne Bryan C · Allen, TXN5265JSouthern Machine And Steel Inc · Fort Myers, FLN5267VN5267v LLC · Northbrook, ILN526CHSky West Aviation Inc Trustee · Albuquerque, NMN5274YMba Sales LLC · Ridgefield, WAN5275VViatrans LLC · Pryor, OKN5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedN5276VSky West Aviation Inc Trustee · Albuquerque, NMN5277PBennett Glenn D · Kingwood, TXN527JHTugende LLC · Montrose, CON527TCLeonardo Paul A III · Merced, CAN5287ATax Busters Inc · El Paso, TXN5287YMorrow Aviation LLC · Midland, TXN528WARiley David P · South Barrington, ILN5293JWestsand Aviation LLC · Allegan, MIN5296AHobot LLC · Springdale, ARN529ADDcm Air LLC · Canton, MIN52CSBombs Away LLC · Elkins, ARN52HCOak Bay Aviation LLC · Bellvue, WAN52JRAg Tech Farm Services · Gamaliel, KYN52JVSl Leasing Group LLC · Atlanta, GAN52PCDitsch Craig · Hondo, TXN52QTFly Qts LLC · Oconomowoc, WIN52RBHeights Multi Flight Management LLC · Monroeville, NJN52SEPryor Jeff · Santa Barbara, CAN52WXGalaxy Drivers LLC · Dover, DEN5300ARunzel Brothers Aviation LLC · Bensenville, ILN5302VSniader David J · Miami, FLFirst renewal noticeN5313USky Quest 210 LLC · Clarksdale, MSN5314VBurke Sterling M · Olympia Fields, ILN5314XMoody Bible Institute Of Chicago · Spokane, WAN5315XAtarah LLC · Tucson, AZN5316JCocola Gary M · Fresno, CAN5317ABlue Skies Air LLC · Allen, TXN5318ABuchanan Harvey · Townsend, MAN531ECBlue Jets LLC · Rialto, CAN531MHigh Cotton Aero LLC · Murray, KYN5320JCorporate Air Charter Inc · Wilmington, DEN5323URio Farms LLC · King City, CA
Back to AD 75-09-13