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.
N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN249TGHoot Aero LLC · Baton Rouge, LAN24BPMiller Dwayne C · Comanche, TXN24CFAmerica Aviation LLC · Yuma, AZN24CJAtluas LLC · Anna, TXN24CVPacific Air Flight School LLC · Long Beach, CAN24DCCraig Joshua · Bonaire, GAN24ELDye Eric M · Winters, CAN24FWatkins Brian · Los Alamos, NMN24FGCalifornia Department Of Fish And Game · Sacramento, CAN24GBSmith Loren · Great Falls, MTN24GCGreene County Sports Parachute · Loretto, KYN24GVBoyd Aviation LLC · Nashville, TNN24HPYolo County/Yolo County Sheriffs Office · Woodland, CAN24JCEllis Robert W · Gilbert, AZN24KWright Douglas J · Greenwood, INN24KKFlying High Again LLC · Mt Juliet, TNN24KMNorthern Jet Inc · Iron Mountain, MIN24LTPinestate Aviation LLC · Glenburn, MEN24PMHaven Harmony LLC · Sheridan, WYN24REMelendez Jesus · North Miami, FLN24RHBurns Texas Enterprises Inc · Houston, TXN24SCGriffin Samuel C · Doniphan, MON24SGVogel Scott A · Dewey, AZN24SLSkye Tess Airlines LLC · Holmdel, NJN24TBDalks Leasing Inc · Wilmington, DEN24TWCopper Rose LLC · Beaverton, ORN24VEDuke William Thomas · West Point, MSN24VVWheels Up LLC · Land O Lakes, WIN24WWPark Avenue Group Inc · Stuart, FLN2500LRice Nancy Kay · Leesburg, TXN2500QSaydun LLC · Richardson, TXN2500RN2500r LLC · Florence, SCN2500XHolloway James H · Merritt Island, FLN2501JDemaris Darryl G · Baton Rouge, LAN2501QEcological Flight Services LLC · Stuart, FLN2501ULarkin Edmund V · Bogart, GAN2501XRoth Douglas K · Anchorage, AKN25028East Hill Flying Club Inc · Ithaca, NYN2502JMartin Clair L Pesonal Representative · Wasilla, AKN2502RLovell John W · Sherborn, MAN2502UChristensen Alan B · Murphysboro, ILN2502YSkinner Norman D · Osceola, IAN2503ARegistered aircraftN2503JSmith Coyt B · Benton, ARN2503RNicoliei Paul · Ione, CAN2503YGutierrez Gilberto · Lindsay, CAN25047Sunrise Aviation Inc · Ormond Beach, FLN2504JGodinez Mauricio U · San Diego, CAN2504LRogers Carol J · Hampshire, IL
Back to AD 97-01-13