AD 76-14-07 R2
Registered aircraft · 930
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:76-14-07-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2')
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:76-14-07-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2') 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.
N9495XLafranchi Logan Michael · Calistoga, CAN9496THudson Willis C · Hendersonville, NCN9496XPaz Nicolas · La Verne, CAN9499XCovalt Justin D · Arcadia, OKN9500XSky Med LLC · Vinton, LAN9501TNeverland Air Co LLC · Myerstown, PAN9501XFlowers Bobby J · Parksley, VAN9502TSilveria Michael J · Soledad, CAN9509TKline John C · Wolcottville, INN9509XHilliard Keith B · Van, TXN9510XWillett Michael J · North Little Rock, ARN9512XSwagerty Michael P · La Mesa, NMN9515XJones Jeffrey A · Rehobeth Beach, DEN9517TSteele Cody T · Polson, MTN9517XKelley James E · Kennewick, WAN9518TParks Paul E · Titusville, FLN9521XTailwynns LLC · Lake Placid, FLN9525XKuest Louis J · Anchorage, AKN9527TTechnical Education Services Inc · Virginia Beach, VAN9529TGarcia Richard E · Atwater, CAN9530TNewby Harold A · Ramona, CAN9530XNelson Design & Engineering LLC · Portland, ORN9531XMaclean James Shier III · Coppell, TXN9533TWarren Roderick D · Hiawatha, KSN9534TSale Reported · Spring, TXSale reportedN9534XCarlson Layne E · Twin Bridges, MTN9535TGelner Ronald L · Pearland, TXN9535XBesties Properties LLC · Fergus Falls, MNN9537TSky West Aviation Inc Trustee · Albuquerque, NMN9538XTodd Robert L · Alvarado, TXN9540TChino Aviation Inc · Chino, CAN9541TNevill John D · Tahoka, TXN9542TLarsen Richard A · Wannaska, MNN9543XBarth Samuel · Fonda, NYN9544XB&B Aviation LLC · Arlington, WAN9545XRichardson Dana C · Okeechobee, FLN9546TAerographics Inc · St Cloud, MNN9547XCundiff Zackery A · Klamath Falls, ORN9548XMclenaghan Alvin · Phoenix, AZN9553XMccarthy Sean P · Jacksonville Beach, FLN9558TWatson Stephen C · Flemingsburg, KYN9560TStern Harvey W · Middletown, NYN9561XAirxn LLC · Williams, AZN9562THiggs Jared E · New Boston, TXN9562XMclenaghan Alvin N · Phoenix, AZN9563XGraham Raymond S · Citra, FLN9564TAlvarado Ruben Jr · Brownsville, TXN9565XBerkbiegler Allen L · Lonedell, MON9569TThomas Richard E · Lafayette, TNN9569XStepair LLC · Spring Valley, OH
Back to AD 76-14-07 R2