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.
N228TMMacs Seaplane Service LLC · Milan, INN228WBSnell Jeffrey D · Inver Grove, MNN228ZFFandrich Edward I · Payson, AZN22900Swanton Jed M · Shawnee, KSN22902Easterling William R · Pikeville, NCN22903Walther Newell A · Wasilla, AKN22905Yokota Flight Training Center · Apo, APN2290GHooker John L · Iowa Park, TXN2290SElco Avion LLC · Eagle Lake, TXN2290XMatthews Roy E · Sparta, MIN2290YHerren Roger L · Clayton, ILN22915Sprankle Gerard · Fairbanks, AKN22919Brozzo Ralph · St Johns, FLN2291EDv Aviation Inc · Brainerd, MNN2291YWyatt Gary D · Sun City West, AZN22920Jackson Kenneth R · Stephenville, TXN22921Sakry Robert J · Saint Joseph, MNN22924Hirkala Ronald R · Weirton, WVN22926Gossett Rita M · Granbury, TXN22927Hamilton Gregory J · Avon Lake, OHN2292CKlein John T · Austin, ARN2292GNelson Erik · Exeter, NHN2292YJess Lawrence A · Menomonie, WIN22935Tift Aviation LLC · Tifton, GAN2293FTwo Mile High Mining LLC · Victor, CON2293GEischen Kent A · Smoot, WYN2293JFrey Jerry P · Fallon, NVN2294CHitch Dixon S · Malta, MTN2294GHenderson Ramsey H · Pittsboro, NCN2294RSeeliger Jeremy E · Pasco, WAN2294XCsc Delaware Trust Co Trustee · Wilmington, DEN2294YHeathfield William T · Plymouth, MIFirst renewal noticeN22956Thyfault Raymond E · Mattawan, MIN2295JPloyhart Edwin J · Harwood, NDN2295WBraswell Jerrold W · Dillingham, AKN2295YHutto Azel James III · Lexington, SCN22963Swift John S · Santa Barbara, CAN22964Straight Flight Aviation LLC · Goliad, TXN2296TRegistered aircraftN22970Kingdom Air Corps · Sutton, AKN2297SRocketjet LLC · Incline Village, NVN2297YKomulainen Daryl B · Clarksville, TNN22980Salt City Aviation LLC · Hutchinson, KSN22988Runyon James R · Entiat, WAN2298GPerkins Larry L · Wildomar, CAN2298JRoth Mark E · Stevensville, MTN2298TT C Rocket LLC · Traverse City, MIN22990Peterson Curtis L · Smith Center, KSN22991Dan Munson Consulting Pllc · Seneca, SCN22998N22998 LLC · Middletown, DE
Back to AD 97-01-13