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.
N2928JVu Huy T · San Diego, CAN2928SDoubler Endeavors LLC · Orlando, FLN2928UHeim Christopher J · Beavercreek, OHN2928YDiamond X LLC · Elko, NVN29292Skytime Aviation LLC · Tulsa, OKN29299Svetic Russell T · Redondo Beach, CAN2929CSinnott Simonis Lyle · Girdwood, AKFirst renewal noticeN2929FSmith Lane R · Lewistown, MTN2929STerrell Aviation Inc · Terrell, TXN2929ULarson Michael J · Canton, ILN2929XKot Ronald J · Punta Gorda, FLN292BWSkyline Aviation Services LLC · Miramar, FLN292CAChoice Aviation LLC · Hamilton, MTN292CBPelton Project · Keizer, ORN292DAIndependence Youth Flying Club Inc · Independence, ORN292KFTotal Flight Aircraft Leasing LLC · Apex, NCN292PZMalone Patrick A · Tuscumbia, ALN292RSValiair Limited Company Trustee · Casper, WYN292SSSkydive Guam Inc · Barrigada, GUN293Zer Holdings LLC · Woodinville, WAN29307Lacroix Michael G Trustee · Shorewood, MNN2930EKelly Ronald T Jr · Munhall, PAN2930FWrucke Scott · Horicon, WIN2930JTetil Nicholas M · Fairgrove, MIN2930UWeast Michael D · Artesia, NMN2930XAero Dynamics Flying Club Inc · Mulino, ORN2931AStrategic Aircraft Management LLC · Fairbanks, AKN2931EHoward Charles O · Sonoma, CAN2931JSmith William T · Fort Payne, ALN2931ULudwig Alfred R · Hayward, CAN2931XRegistered aircraftN2931YWiesner Norman P Trustee · Silverton, ORN29320Triple G Aviation LLC · South Point, OHN29321Render Jeff · Peoria, ILN29329Hill Edward J Jr · Dover, DEN2932AHenderson Steven A · Idaho Falls, IDN2932SRutoski Mary Ann · Jordan, MNN29330Rucinski Edward A · Climax, NCN29334Burger Cale L · Hampden, MEN29335Sale Reported · Lebanon, ORSale reportedN2933CLawson Matt E · Gobles, MIN2933FLevinsohn Reuben D · East Lansing, MIN2933SHarry Kevin M · Salisbury, NCN29340Hodges Michael T · Myrtle Beach, SCN29343Aeromech Incorporated · Mukilteo, WAN29344P & P Aviation LLC · Trout Run, PAN29345Bailey Daniel L · Gibsonville, NCN2934ADixon Devin M · Las Vegas, NVN2934FH & S Aviation LLC · Roseville, MNN2934ULison Denis Gregory · Hollis, NH
Back to AD 97-01-13