AD 2012-16-14
Registered aircraft · 779
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:2012-16-14')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-16-14')
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:2012-16-14') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-16-14') 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.
N145VG45xr Ventures LLC · Wilmington, DEN145XLGuardian Flight LLC · Lewisville, TXN146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN146JFJ F Air Traffic Inc · Temple, TXN150CTBank Of Utah Trustee · Salt Lake City, UTN150GAJa Aviation Holdings LLC · Orlando, FLN150GVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN150JNG150mt LLC · Franklin, TNN150LPTvpx Trust Co LLC Trustee · North Salt Lake, UTN150RJ513 LLC · Newark, DEN150SBRegistration Pending · Anchorage, AKRegistration pendingN155ERAir Medical Services LLC · Denver, NCN155MEDbe Aire LLC · Wilmington, DEN156NSNunya LLC · Costa Mesa, CAN158ECHhh Aviation LLC · Des Moines, IAN161JCRailjet LLC · Durango, CON163DKHorizontal Ventures LLC · Lowell, INN166RARoyal Air Freight Inc · Waterford, MIN167ATAai Aviation Inc · San Diego, CAN167XPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN16LJLear Holding Corp · Wilmington, DEN16SMJokity Holdings LLC · Richmond, VAN175MGBank Of Utah Trustee · Salt Lake City, UTN176TLBank Of Utah Trustee · Salt Lake City, UTN176USJd76 Air LLC · Chesterfield, MON1776CDvyxv Fund III LLC · Waxhaw, NCN17ENKare Air LLC · Paradise Valley, AZN17RMWard Acres Farms Texas LLC · Austin, TXN17TVBank Of Utah Trustee · Salt Lake City, UTN183CMAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN183TFRueco LLC · Lindon, UTN1893NNewcomer Leasing LLC · Topeka, KSN18AAAtlantic Prime Corp · Miami, FLN18GUKnoc LLC · Hinsdale, ILN1901Buffalo Rock Company · Birmingham, ALN1904S1904 LLC · Elyria, OHN190SWRouse Holdings LLC · Schriever, LAN1910AKms Air LLC · West Bend, WIN1910HHallmark Cards Inc · Kansas City, MON191LJAviation Resource Group Inc · Fort Lauderdale, FLN191TDRichards Aviation Inc · Memphis, TNN1925PRegistered aircraftN1927GDodson International Parts Inc · Rantoul, KSN192SAAdams Aviation LLC · Charlotte, NCN1932A H Beck Foundation Co Inc · Converse, TXN193SGSunshine Sky Aviation LLC · Doral, FLN197ECTeam Aero LLC · Shawnee, KSN1980RRae Mae Air LLC · Coraopolis, PAN19KBKontoor Services LLC · Greensboro, NCN1DKDonkaraphillips LLC · Tampa, FL
Back to AD 2012-16-14