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.
N2802UPatterson Bud N · Perry, OKN2803KMunro Gregg · Kenmore, WAN2803USwan Aviation Ministries Inc · Laurel Hill, FLN2803XStamper Douglas H · Norfolk, VAN2803YDakota Aircare Inc · Wagner, SDN2804CCampbell Mark · Burleson, TXN2804FChristensen David W · Lyman, UTN2804RBarnhill Gregory L · Leawood, KSN2804SAlmy David W · Riverside, CAN2804YLyons Brian E · Cortez, CON2805AWeibert Jarvis Tye · Kalispell, MTN2805KNorthstar E & C LLC · Anchorage, AKN2805QA L Hollandsworth LLC · Columbia, MON2805UContinental Skylarks Inc · Deer Park, NYN2806AJackson Todd M · East Wenatchee, WAN2806EBexar Aviation LLC · San Antonio, TXN2806QLawson Lance J · Sikeston, MON2806UWeeber Charles · Pelham, MAN2806YPautler Justin H · Alden, NYN2807AWoodley Aerial Leasing LLC · Walnut, ILN2807EMission One LLC · Excelsior, MNN2807KLeseberg Mark E · Minden, NVN2807LBerisha James · Porter, TXN2807QReynolds David F · Port Orange, FLN2807UMeese Brian D · Conroe, TXN2808KCam Corporation · Fairbanks, AKN2808RInman Matthew · Gallatin, TNN2809FOverbaugh Gary R · Highland, UTN2809LWarner Walter M Jr · Willow, AKN2809RTerwillegar Charles E · Renton, WAN2809UBleskan Erick J · New Berlin, WIN2809XGuckian Jim J · Riverdale, GAN280HB280hb LLC · Brighton, MIN280HPTextron Aviation Inc · Wichita, KSN280JGEdwards Jonathan S · Marysvale, UTN280JPDraaisma Jacob Jr · Middleville, MIN280MSM & S Air Service Inc · Honeoye Falls, NYN280SLRamer Scott A · Dornsife, PAN280SWKatie Investments Inc · Little Rock, ARN2810FDancing On Blue Lc · Las Vegas, NVN2810KWair Inc · Mount Vernon, WAN2810QMcdowell Kevin J · Williamsburg, VAN2810RSeller Mark E · Hutchinson, MNN2810SWaco West Inc · Dover, DEN2810UN2810u LLC · Delray Beach, FLN2810VDipasquale Glenn D · Gloversville, NYN2811FLien Craig C · Plains, MTN2811KHayward Houston C · Lansdale, PAN2811YCotti Kevin P · Plymouth, MAN2812KSylvester John A · Hereford, AZ
Back to AD 97-01-13