AD 81-13-10 R1
Registered aircraft · 4,001
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:81-13-10-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1')
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:81-13-10-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-13-10-R1') 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.
N337GSJc Holding LLC · Wilmington, DEN337HSCatering Of Central Texas Inc · Kerrville, TXN337JJJodice Timothy · Amherst, NHN337JLDavis Mike D · Huntersville, NCN337JRInternational Air Services Inc Trustee · Carson City, NVN337JSI V S K LLC · Wilmington, DEN337KErwin Richard L · Killen, ALN337KHValiair Lc Owner Trustee · Casper, WYN337KTSky West Aviation Inc Trustee · Albuquerque, NMN337LASturgeon Kenneth V · Winter Garden, FLN337LFA To B Flying Inc · Litchfield, ILFirst renewal noticeN337LPSkymaster Stc LLC · Mena, ARN337MMAugugliaro Robert J · Albuquerque, NMN337MWMtw Aerospace Inc · Montgomery, ALN337NEAviation Specialty Services LLC · Beaufort, NCN337PHayes James J · San Diego, CAN337PPStreeter Adam W · Grand Prairie, TXN337RTillman Tracy S · Webberville, MIN337RCN337rc Corp Trustee · Wilmington, DEN337RDDamschroder Rex A · Fremont, OHN337RGStephens Kenneth Joe · Bristol, TNN337RJWilson Scott · Sheridan, WYN337RRLara Oscar · Bonita, CAN337RSDinwiddie Michael R · Sunbury, OHN337RTTorres Ramon A · Mulberry, FLN337RWRamey Chris M · Simpsonville, KYN337SSState Of Wisconsin/Doa · Madison, WIN337SVLillie Ronald G · Salt Lake City, UTN337TGSafe & Sound LLC · Kalispell, MTN337TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN337TLInternational Air Services Inc Trustee · Carson City, NVN337TRDel Rio Aviation Inc · Paso Robles, CAN337TSWalz Steve · Kiowa, KSN337TWRtw Aviation LLC · Tulsa, OKN337TXBlue Skies Aviation Services LLC · Bynum, TXN337USkymaster Mods & Parts LLC · Castalian Springs, TNN337VRed Devil Skymasters LLC · Helena, MTN337VGBvj Skymaster Inc · Appleton, MNN337WAGyron Eagle Ltd · Pasadena, CAN337WGGrady Charles Martin · La Verne, CAN337WTSunset Aviation LLC · Wilmington, DEN337WWTobias John M · Sedona, AZN337WZAir Data Solutions LLC · Natchitoches, LAN337XXPfister David E · Harlan, INN337YBrokaw Burton · Tucson, AZN33809Iaba LLC · Norfolk, VAN33832Shafer James H · Port Orchard, WAN33833Buchholz David M · Scottsdale, AZN338DDAltered Dimensions LLC · Noblesville, INN338PAFl Ventures I LLC · Winter Park, FL
Back to AD 81-13-10 R1