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.
N23106Spencer Standlee B · Mineola, TXN2310RMccarty Brian Keith · Huntsville, TXN2310SWest Alabama Aircraft Leasing Inc · Tuscaloosa, ALN2310UTec Aviation LLC · Euclid, OHN23111G Force Advantage LLC · Lewes, DEN23112Philp Robert J · Lysite, WYN23114Page Audra L · Shutesbury, MAN23117Cessna 23117 Aviation Services LLC · Colorado Springs, CON2311CB & B Aviation LLC · Wayzata, MNN2311FPace Seth M · Malibu, CAN2311GVan Winkle Randy M · Van Buren, MON2311UDcy Flyers Inc · Montgomery, INN23123Gafford Brian A · Lewis Center, OHN23125Maldonado Cesar O · Utuado, PRFirst renewal noticeN23128Keeny Kenneth K · Stewartstown, PAN2312FButler Scotty · Yukon, OKN2312REagy Gregory L · Boise, IDN2312XCain James W · Big Rapids, MIN23133Gill Robert S · Woodinville, WAN2313RBlackman David M Trustee · Pacifica, CAN2313UNobles Homer L III · Sandy Valley, NVN23144Henry Ronald E · Sullivan, OHN23148Blunt Christopher G · Chippewa Falls, WIN2314EAirgo Inc · Centralia, ILN2314GFallang Paul Sam · Great Falls, MTN2314RWilson George L · Hideaway, TXN2314UCms Crawford Maintenance Services LLC · Largo, FLN2314XFlight Resources LLC · Monroe, GAN23153Riser Natalia Lang · Montgomery, TXN23156Brooks Clifton B · Harrah, OKN23157Hubler Eric William · Caldwell, IDN23158Schumacher James A · Woodinville, WAN2315CRegistered aircraftN2315FRed Rock Aircraft Leasing LLC · Hurricane, UTN2315GClark Jeffrey E · Tiburon, CAN2315XParker Ronald Lewis · Melissa, TXN23162Dillon R Patterson Professional Services LLC · Prescott, AZN23167Walker Timothy M · Brockport, NYN2316CTwo Wings LLC · Anchorage, AKN2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARN2316YWhitacre James P · Martinsburg, WVN23174Stewart Ellen D · Trafalgar, INN2317XSproul Wendell C · Hermon, MEN23187Pollauf James W · Northwood, OHN23188Reginald Caudill · Hi Hat, KYN2318CWebster Robert C · East Jordan, MIN2318FBe Dozer LLC · Guy, ARN2318GRedmond John R · Reno, NVN2318RJigamian Geoffrey T · Temecula, CAN23193Smith Roger D · Fayetteville, NC
Back to AD 97-01-13