AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N7485APrecup Michael P Sr Trustee · Perrysville, OHN7485CYanover Joseph J · Traverse City, MIN7485EJacques Steve C · Centennial, CON7485GIndependent Aviation Services LLC · Sachse, TXN7485MLyons Adrian K · Torrance, CAN7485QEvans Charles H Trustee · Hooksett, NHN7485XEngland Robert C · Zanesville, OHN7486MYaeger John F · Au Gres, MIN7486SGarage Doors Of Greenville LLC · Greenville, MSN7486TRhodes Vergil H Jr · Bartlesville, OKN7487ANelson Rodney G · Amenia, NDN7487GRich Aviation Services LLC · Fort Worth, TXN7487MMaple Lake Flyers Corp · Maple Lake, MNN7487Q206 LLC · Anchorage, AKN74887Mroz Kaitlin J · Haslet, TXN7488MFegert Jeff · Las Vegas, NVN7489AAllianna LLC · Fayetteville, ARN7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLN7489MMerinar John R Jr · Bridgeport, WVN7489QLlano Masonry LLC · Lubbock, TXN748CPCivil Air Patrol · Maxwell Afb, ALN748KPKalinin Partners LLC · Juneau, AKN748MKAero-Tech Services Inc · Lititz, PAN748SPBg-Ip LLC · Saratoga, CAN748WPParker Charles W III · Anchorage, AKN748XMorgan Bryon E · Eugene, ORN749United States Department Of Interior · Boise, IDN7490XDawson Ejay J · Eveleth, MNN7491AMckee Paul R · Astoria, ORN7491EBenscoter Richard S · Nordman, IDN7491GAccess Air Service Inc · Mercedita, PRN7492TSale Reported · Newport, ORSale reportedN7493GHaugo Robert P · Scobey, MTN7493TLee Cody C · Denton, MTN7495MPlumley David E · Waxhaw, NCN7495XIsch Philip D · Geneva, INN7496AMcreynolds Sean D · Visalia, CAN7496MMcmurray Patrick T · Brush Prairie, WAN7496XAbove All Aviation Inc · Santa Barbara, CAN7497AJohnson Kurt W · Jordan, MNN7497EDunford David R · Maryville, TNN7497TLeffler Greg L · Zion Crossroads, VAN7497XTrinciante Fernando S · Thief River Falls, MNN7498ATorrey Robert S · Anchorage, AKN7498TLala Princy · Deltona, FLN7499ADurousseau Joseph Harry Trustee · Sparks, NVN7499CHillsboro Flying Club · Hillsboro, ORN7499TWright Donald E · Greensboro, NCN7499XVintage Aircraft Ltd · Hortonville, WIN749KPKalinin Partners LLC · Juneau, AK
Back to AD 79-10-14 R1