AD 77-07-06
Registered aircraft · 361
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:77-07-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-07-06')
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:77-07-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-07-06') 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.
N323HADale Aviation Inc · Rapid City, SDN330VAlcovy Mountain Venture LLC · Monroe, GAN332DEMetro Aircraft Co · Bloomington, MNN332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCN333TLBrad And Jill Janecke LLC · Pierre, SDN339KAChenango Aviation LLC · Dallas, TXN33FRCharles L Fridge III Pc · Houston, TXN34CEFirst Call Home Health Agency LLC · Salem, ORN34MFDavis Aviation Inc · Brandon, MSN351GRDodson International Parts Inc · Rantoul, KSN35BAC90 Air Inc · Lemoore, CAN35CVNavajo Enterprises LLC · Schwenksville, PAN35TVN35tv LLC · Shawnee, OKN362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKN366GWK&K Leasing Inc · Tea, SDN3690FWv Gastro & Endo LLC · Wheeling, WVN3695WSuarez-Ballardo Jorge Luis · Glendale, AZN369WTSterling John · Port Lavaca, TXN36TGRv Holding LLC · Winchester, MAN3700MBoeing Co · Berkeley, MON377PUig Transport LLC · Raleigh, NCN379VMShores Kenneth E · Robstown, TXN3805EHollow Creek Investments LLC · Germantown, TNN3818C18 Charlie LLC · Southern Pines, NCN38280Aerotrust Services Corp Trustee · Wilmington, DEN383AAAzul Air LLC · Dover, DEN383ASLee Holdings & Investments LLC · Marks, MSN385EMEmerald Aviation Inc · Manassas, VAN386GABarnes Inc · Lewiston, IDN388KFKiernan Companies LLC · Englewood, CON390PSMcm Holdings Inc · Lincoln, NEN39FBButler National Inc · New Century, KSN3GCTexas Air & Space Museum · Amarillo, TXN3LSConcept Management Company LLC · Spartanburg, SCN400RVMach Point Nine LLC · Phoenix, AZN403EMMach Point Nine LLC · Phoenix, AZN404JPParish Planes LLC · Tullahoma, TNN406SFNew Mexico State University · Las Cruces, NMN410MCBank Of Utah Trustee · Salt Lake City, UTN416BKOptic Air LLC · Maurice, IAN41BAFly Kronstadt LLC · Evanston, ILN422PMDale Aviation Inc · Rapid City, SDN425W4js LLC · Holland, MIN427DMSky Charter LLC · Slidell, LAN42PCKrohn Aviation LLC · Springfield, OHN431BGBismarck Air Medical LLC · Bismarck, NDN439WAA W Peterson Inc · Warren, MNN43PCOlsen Air LLC · Hendricks, MNN443CLSkiing Aircraft Co LLC · Bloomfield Hills, MIN4447WJvs86 LLC · Scottsdale, AZ
Back to AD 77-07-06