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.
N3099UCotter William P · Elkhart, KSN3099YPerkins Scott B · Thomas, OKFirst renewal noticeN309LLSweepyacres LLC · Greenbrier, TNN309MMDavenport James M II · Hollywood, FLN30AWKnox Tommy J · Lampasas, TXN30CMBoardman Air Service LLC · Henderson, NEN30CTLaidley Robert F · Erie, CON30DBBouchard Dean · Glendive, MTN30DTShelton Sharon Shay · Abilene, TXN30EEEnterprises Aviation Inc · Piedmont, SDN30EWThree Zero Echo Whisky Inc · Wilmington, DEN30FBBmg Aviation Leasing LLC · Bloomington, INN30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeN30GEEagle Air Inc · Schoolcraft, MIN30GPCedar Mountain Respiratory Inc · Athol, IDN30GSClausen Robert G · Argyle, MNN30HBN30hb LLC · North Miami, FLN30HCKinetic Concepts LLC · Pensacola, FLN30JAJahawk Leasing LLC · Sugar Grove, ILN30LDPartlow David D Jr · Pahoa, HIN30LPDialysis Clinic Inc · Nashville, TNN30LTJuans Adios LLC · Newark, DEN30MSFlying Medical Service · Grosse Pointe, MIN30MTMcnamara J Kevin · Cascade, IDN30MUOracle Aviation LLC · Omaha, NEN30PTGas Aviation LLC · Decatur, TNN30RHHalye Roger J · Port Orange, FLN30RJBrookshire Joseph E · Erie, CON30RWSaltzy Seas LLC · Loxahatchee, FLN30STennessee Technology Center At Morristown · Morristown, TNN30SSN30ss LLC · Dover, DEN30TGCarter Jesse E · Milford, OHN30WEWest Elk Air LLC · Gunnison, CON30WLSkydive Coolidge Inc · Tempe, AZN3100CBannon Daren · Douglass, KSN3100DDiel Mark A · Walnut Creek, CAN3100FBurger Todd Richard · Helena, MTN3100RCentral Oklahoma Aviators Flying Club · Piedmont, OKN3100SSinnissippi Aviation LLC · Beloit, WIN3100YWhalen John F · West Ossipee, NHN3101CFreefall Fever Inc · Edgewater, FLN3101JRobinson David N · Colleyville, TXN3101TMission Air LLC · Charlotte, NCN3101XBlalock Bernnie R · Washington, OKN3101YJazzminate Inc · La Mesa, CAN3102DOsowski Christopher J · Anchorage, AKN3102FWhitfield Timothy D · Fairfield, NCN3102XJoshua Aircraft LLC · Georgetown, DEN3103CBay Kelly M Trustee · Glennallen, AKN3103FJorgensen Bryan K · Kingston, GA
Back to AD 97-01-13