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.
N30546Brady Dennis J Jr · Chesterfield, MON30547Wright Thomas L · Clyde, OHN30549Lad Custom Publishing Inc · Buford, GAN3054EPrinceton Flying Club Inc · Wilmington, DEN3054FAirlaska LLC · Gustavus, AKN3054XHeidt Daniel A · Opelika, ALN30553Jfe LLC · Flossmoor, ILN30556Amundson Clyde E · Poplar Grove, ILN30557Wilson Thomas L · Sheboygan, WIN3055XChickasha Wings Inc · Chickasha, OKN30565Flowings LLC · Orlando, FLN30567Sale Reported · West Liberty, KYSale reportedN3056JRegistration Pending · Jackson, MIRegistration pendingN3056USchans Richard L Sr · New Bern, NCN3056XSmith Chelsea R · Louisville, KYN3056YBardack Barry L Trustee · El Cajon, CAN30570Gallacher Mark A · Salem, UTN30571Spencer Burton D · Mchenry, ILN30574Carter Peter M · Elkhorn, WIN30578Rhodes Michael · Jacksonville, FLN30579Dry Creek Services LLC · Lodi, OHN3057JGaines Von J · Hendersonville, TNN3057QJoseph C Casey · Lufkin, TXN3057SMcabee Patrick A · Tampa, FLN3057UDesousa Raphael · Fremont, CAN3057XSoules William P · Las Cruces, NMFirst renewal noticeN3057YJjm Aviation LLC · Newport, NCN30583Roviaro Edward · Schererville, INN30584New Horizons Aviation LLC · East Helena, MTN30593Valiair Lc Trustee · Casper, WYN30597Brewer Aviation LLC · Winslow, ARN30599Wilson Phillip W Jr · Kailua, HIN305ACTascosa Trail Inc · Gruver, TXN305DWPugleasa William Hunter · Lowell, ARN305FStockdale Aviation LLC · Crawford, CON305KWPumpkin Eater LLC · Tavares, FLN305MJRegistration Pending · Phoenix, AZRegistration pendingN305NCNca Aircraft LLC · Opa Locka, FLFirst renewal noticeN305PTCappe Investment Group LLC · Homestead, FLN305PYUfly Vi LLC · St Thomas, VIN305SLSealand Airways Miami LLC · Miami, FLN305WBCardinal Aviation LLC · Charles City, VAN305XXDs Group LLC · Miami, FLN30603Registered aircraftN3060QYarg Tap LLC · Midland, TXN3060UWhipple James M · Wadsworth, OHN30612Wheeler Vincent · Harwinton, CTN30615Yanichko Robert · Weeki Wachee, FLN30617Executive Flight Training & Services LLC · Sanford, NCN3061FTaber Deane W · Weirsdale, FL
Back to AD 97-01-13