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.
N2728BBig Island Gravity LLC · Kapaau, HIN2728JWahlberg · Pearland, TXN2728LPotter Mark H · Santa Rosa, CAN2728UCatsakis Andrew W · Lovettsville, VAN2728XUsda Forest Service Fepp · Trenton, NJN2729FSexton & Sanders Law Firm Pa · Fort Smith, ARN2729LVip Wellness LLC · Victoria, TXN2729QCraft Phyllis C · Damascus, GAN2729SDates Lauren C · Red Creek, NYN2729UDenair Inc · Canandaigua, NYN272BBearair II LLC · Libertyville, ILN272DBBrock Dean R · Hawthorne, FLN272DKKroutil David W · Hilmar, CAN272JAGold Coast Aviation LLC · Oxnard, CAN272NSKroeber Thomas · Pawlet, VTN272RARomeo Alpha Flyers Inc · Nashville, TNN272RRGray Kerry · Monterey, CAN272SCRobert Gardner Enterprises LLC · Mercer, MEN272TLSanders Flight Training Center · Jasper, ALN272TNReed Perry L · Mooresville, NCN272VWigley Ben Jr · Huntington, ORN272WCCandace A Larned Enterprises Inc · Long Beach, CAN2730EOew Aviation LLC · Sumter, SCN2730MSua LLC · Artesia, NMN2730QSkylane Corp · Pittston, PAN2730XSmith Daniel E · Anchorage, AKN2731JPatry Aeronautical Institute · Kalispell, MTN2731KYoung Aviation LLC · Oshkosh, WIN2731Q31q LLC · Boise, IDN2731UKemp Gilbert A · Waterville, NYN2732GPrince Benjamin D · Lincoln, MTN2732KDixie Sand And Gravel LLC · Edisto Island, SCN2732LGlenndale LLC · Jackson, MON2732SBryan Aviation Co LLC · Oelwein, IAN2732TJellor Realty Inc · Los Angeles, CAN2732UDavenport Jimmy J · Hayesville, NCN27339Rice John G · Craig, AKN2733FMetzger William M · Boonville, INN2733GSkydive Ky LLC · Cecilia, KYN2733LHugelman Frank J III · Waynesville, MON2733VOlson Kirk · Dickinson, NDN2734BStella Air Inc · Wyoming, PAN2734FWard Christopher C · Lufkin, TXN2734GSplit Rock Aerospace LLC · Southport, CTN2734HGriebel Kyle L · Lafayette, CON2734JHelbig Frederick E · Oakland, MDN2734Q1175 Bangtail Way LLC · Greycliff, MTN2734URegistered aircraftN2735GGaunt Galen B · Glennallen, AKN2735JAlpha 414a LLC · New Smyrna Beach, FL
Back to AD 97-01-13