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.
N4235CColville LLC · Signal Mountain, TNN4237CBreakaway Group Aviation LLC · Franklin, TNN423BWFehring William · Sunnyvale, CAN423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEN423TMJp Aviation Leasing LLC · Salt Lake City, UTN424JN424 Juliet LLC · Mesa, AZN424MEKfl LLC · Canyon Country, CAN424PCMontana Livestock Ag Credit Inc · Helena, MTN4255STeton River Flying Service Inc · Rexburg, IDN4264CMmc Properties LLC · Cottonwood, AZN4272CKamps Air LLC · Grand Rapids, MIN42776Hap'S Air Inc · Ames, IAN427BDNostra Aeris LLC · Gassville, ARN427DWFlyin Phar LLC · Salt Lake City, UTN4287AWilliam Dolson And Associates LLC · Santa Fe, NMN428AJetpropmontana LLC · Cameron, MTN429GMResendiz Marcelino · Alamo, TXN429RCN429rc LLC · Gladwyne, PAN42AMGruhlkey William H · Wildorado, TXN42BCRotary Components International Inc · Houston, TXN42BDKristoferson John S · Denton, TXN42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationN42CWHollywood Of The South Flight School Ltd · Decatur, GAN42MWWalker Winston W Trustee · Tucson, AZN42NCCapair Inc · Plantation, FLN42SGPolar Star Co · Wilmington, DEN42SMBaron South LLC · Dexter, MON42WBCity Of Mesa Arizona · Mesa, AZN42YZPharaoh Aviation LLC · Velma, OKN4304CN4304c LLC · Pawhuskah, OKN4308ZMike Victor Yankee LLC · Andover, MAN4312VBaron Be 58 LLC · Essex, MTN4315COld Salt Aviation LLC · Virginia Beach, VAN4319MSale Reported · Aptos, CASale reportedN431CELegacy Aviation LLC · Ann Arbor, MIN4323BBkt Holdings LLC · Mont Belvieu, TXN4323POverspray LLC · Norfolk, NEN4326CSeven Echo Whiskey Corp · Wilmington, DEN432RADirect Entry Holdings LLC · Port Richey, FLN43362Plane Fun Inc Tr Trustee · Snellville, GAN43368Triple 4 Aviation LLC · Martindale, TXN433BPLeverock Richard C · Port Saint Lucie, FLN43412Registered aircraftN4341NGg And Sg Properties LLC · Seminole, FLN4358MKimt LLC · Iron Mountain, MIN4360VMb Powers Inc · Thompsons Station, TNN4363LVeritas Holdings LLC · Washington, DCN4363MArk 84 LLC · Wilmington, DEN4366ZEse Aviation LLC · Houston, TXN436MHaase LLC Series 5 · Henderson, NV
Back to AD 75-09-13