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.
N9313DSteneker Siardus L · Vashon, WAN9313GSchwend Brian · Forsyth, MTN9313HFlying Ten Flying Club · Phoenix, AZN9313XSjb Farms LLC · Albany, ORN9314CThielker Mark Robert · Bellaire, TXN9314EHall Kenneth B · Merritt Island, FLN9314GPeerbolte John K · Highland, INN9314XFortney Rick · Mc Alpin, FLN93157Haley Mitchell P · Big Lake, MNN9315BVan Horne Robert E · Centralia, ILN9315C15charlie LLC · Soldotna, AKN9315DZoviv Michael · Hollywood, FLN9315ESmith Mark S · Cornville, AZN9315UGilbreath Brent · Arlington, TXN9315XBowen Floyd Eugene Jr Trustee · Bend, ORN9316BKnutson Wayne R · Thompson, NDN9316URoadrunner Bus LLC · Weston, NEN9316XZilberberg Tamir · North Hollywood, CAN9317Avignati West LLC · Santa Barbara, CAN9317CSixus LLC · Fairfax, VAN9317EBrothers Brian · Columbus, OHN9317MWestwind Aviation Inc · Phoenix, AZN9317WBruton Paul R · El Campo, TXN9317XMoonshine Energy LLC · Midland, TXN93183Frost John David Trustee · Anchorage, AKN93186Bates Byron B · Ethel, WAN93189Hoppner Theodore · Fairbanks, AKN9318BAnderson Daniel R · Venus, TXN9318UWhite David A · Omaha, ARN9318XTopnotch Aero Inc · Austin, TXN9319HHoffman Stanley L Jr · Bethel, AKN9319UJohnson Douglas G · Mason City, IAN9319XShepherd Joseph R · Fayetteville, GAN931EMClackamas County Sheriffs Office · Oregon City, ORN931MSColeman Aviation LLC · Livingston, TNN931SJTss Flying Club Inc · Bethesda, MDN931URRegistration Pending · Ivins, UTRegistration pendingN93202Nature State LLC · Portland, ORN9320CRiley Coda L · Beaumont, TXN9320DDodson International Parts Inc · Rantoul, KSN9320GChiles Farms LLC · Hooper, CON9320HPlane Tail LLC · Bethany, CTN9320XBlue Skies Air LLC · Portland, ORN93216East Moriches Aerial Advertising Ltd · Ridge, NYN9321BGippner Gerald W · Olathe, KSN9321EMertinez Matos Daniel Enrique · Fajardo, PRN9321GFontana Michael A · Kirkwood, MON9321XSakonnet Aircharter · Bradenton, FLN93229Back Country Club LLC · Crawford, TXN9322CWaters David J · Phelps, NY
Back to AD 79-10-14 R1