AD 97-25-01
Registered aircraft · 3,184
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-25-01')
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-25-01')
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-25-01') 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-25-01') 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.
N135RWOneal Eric T · Geneva, FLN135SSTextron Aviation Inc · Wichita, KSN136KFFisher Auto Parts Inc · Staunton, VAN136PAX-Press Charter Service Inc · Longview, TXN137FLCharlie-001 LLC · Sugar Grove, ILN138MMTextron Aviation Inc · Wichita, KSN138PBSouth Delta Aviation Inc · West Helena, ARN138PLCpg Air LLC · Skaneateles, NYN138TLHarvest International Ministries Inc · Texarkana, ARN139JBQuay Ventures LLC · Alto, TXN139RRRyan Renae L Trustee · Wichita, KSN139SCNew Ulm C90 LLC · Marshall, MNN13FPSafeco Leasing LLC · Port Alsworth, AKN13GZGuardian Flight LLC · South Jordan, UTN13PECamm Air · Spencer, IAN140HAxis Transportation Services LLC · Sacramento, CAN140MCPlane To Sea LLC · Raleigh, NCN140MNTextron Aviation Inc · Wichita, KSN140RLN140rl LLC · Kalispell, MTN141LVictor One Four One LLC · Boston, MAN141SMInfinity Aeronautics LLC · Greer, SCN141SULynch Family Companies Inc · Waucoma, IAN142EBFly Me LLC · Mc Gregor, TXN142MNTextron Aviation Inc · Wichita, KSN143DEAac 585 LLC · Kennesaw, GAN143DSBen-David Meir · Woodland Hills, CAN143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN143NDepartment Of Homeland Security · Washington, DCN143TAJrr Motor Sales LLC · Campbellsville, KYN144CMeyers Construction Inc · Fresno, CAN1459General Atomics Aeronautical Systems Inc · San Diego, CAN145AFDale Aviation Inc · Rapid City, SDN146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN146ZUtah State University · Logan, UTN147LJGuardian Flight LLC · Lewisville, TXN148AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN149CCCianbro Corp · Baltimore, MDN14HHDelaware Professional Aviation LLC · Dalton, GAN14NGFirst Avenue Management LLC · Savannah, GAN14NMDriscoll Health Care Services · Corpus Christi, TXN14PGorman Aviation LLC · Bartlesville, OKN14SBMountain Air Aviation LLC · Jonesville, VAN14VDouble D International LLC · Miami, FLN14VPAmerican Woodcraft LLC · Fort Denaud, FLN150CNKing Air Investments LLC · Ferriday, LAN150GWRocinante Air LLC · Cincinnati, OHN150GXWest Penn Aviation LLC · Midland, TXN150RFR & F Wings III LLC · Liverpool, NYN150RLTigress Air III LLC · California, MDN150TWCentral Virginia Aviation Inc · North Dinwiddie, VA
Back to AD 97-25-01