AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N19878Oxford Flying Club LLC · Oxford, NCN1987GPhillips Michael M · Angleton, TXN1987ZN1987z LLC · Jordan, NYN19880Mach 1 Pilots Association Inc · Hillsborough, NJN19881Nichols Philip · Royse City, TXN19882Morris Robert Alexander · Carencro, LAN19886Silver Express Co · Miami, FLN19887Kidd Joseph N · New Smyrna Beach, FLN19888Harp Marlin D · Collinsville, TXN1988MFacility Concepts LLC · Jackson, MSN1988XN1988x LLC · Erie, CON1988ZMessner Mark R · Chesapeake, OHN19895Fms Aviation LLC · Littlestown, PAN19896Herrera David D · Duncan, OKN19897Edwards Richard V · Acampo, CAN19899Fly7 LLC · Pompton Plains, NJN1989EInteriaires LLC · Redwood Falls, MNN1989MCrosswind Aviation LLC · Friendswood, TXN1989QDelta Bravo Aviation · Byron Center, MIN1989ZBehnke James R · Fort Collins, CON198ARNielsen Jeffrey S · Ashland, ORN198AZCoyote Aviation LLC · Ballston Spa, NYN198JMBlazey James R · Palmyra, NYN198PBolski Dariusz · Rancho Cordova, CAN198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKN19900Mcwhorter Christopher W · Rose Hill, KSN19905Saffer Dallas L · Flagler, CON19907Fly Pioneer Valley LLC · Gill, MAN19908Sale Reported · Miami, FLSale reportedN1990VBuehn Tamara K · Fallon, NVN1990XCedar Valley Lumber Company LLC · Fullerton, NEN19910Chavez Tyson R · Henderson, NVN19913Wings Over Texas Holdings LLC · Denton, TXN19914Ursa Major Holdings LLC · Newark, DEN19916Barbour Benjamin E · Huntersville, NCN1991PMyron Holdings LLC · Puyallup, WAN1991QJohnny Becker LLC · Helotes, TXN1991XTree-O LLC · Daphne, ALN19928Gibson Christopher R · Natchez, MSN1992XBush Richard A · Mccall, IDN19934Falcons Flying Club Inc · Ridgefield, WAN19936Halsted Barry J Trustee · Sequim, WAN19938Chamberlain Cory D · Holladay, UTN1993MPoskey Charles E · Alabaster, ALN1993QCasper Aire Inc · Saint Cloud, FLN19940Elk & Ram Aviation Group LLC · San Antonio, TXN19944Gray Richard B · Manley Hot Springs, AKN19947Sprynx Aviation LLC · Plano, TXN19948Murray Air LLC · Patoka, ILN19949Skipper Martin D · Orlando, FL
Back to AD 97-01-13