AD 90-02-13
Registered aircraft · 3,863
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:90-02-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:90-02-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:90-02-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:90-02-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.
N310CTIcp Aviation LLC · Melbourne, ARN310CWWahl Charles · Cameron Park, CAN310DARecycled Air LLC · Hoschton, GAN310DFJordan Air Inc · Hugoton, KSN310DLPuzio Scott M · Locust Grove, GAN310DSWorld Marketing Syndicate I · Wilmington, DEN310EBWeatherproof Montana LLC · Missoula, MTN310EDWilson Joseph E W · Austell, GAN310EKCassel Paul · Hernando, MSN310ERAlbrecht Wallace L · Fayetteville, TXN310ESDiamond P Aviation LLC · Riverton, ILN310FADenning Lawrence I · Liberty, MON310FCScott Jed L · Salem, VAN310FFHangar 28 Aviation Holdings I LLC · Cody, WYN310FGMcalpine David B · Fort Worth, TXN310FHDury Aviation Services Inc · De Soto, ILN310FPMorley Thomas O · Riverside, CAN310GGSale Reported · ObersulmSale reportedN310GJRocket City Aero LLC · Huntsville, ALN310GQMayo Ray C Jr · Shreveport, LAN310GRDailey Jordan · Umatilla, FLN310GWM And M Aviation Leasing LLC · Wilmington, DEN310HCGlover David D · Pittsburgh, PAN310HSValiair Lc Trustee · Casper, WYN310JNgugi Samson W · El Paso, TXN310JBBickel Aviation LLC · Wilmington, DEN310JDPritchett Jerry D · Lakeville, MNN310JTCowan David E · Mount Pleasant, SCN310KCMattix Charles B · Temple, TXN310KTSmith Gregory E · White Lake, MIN310LAPorter Kenneth M · Cottonwood, AZN310LBTradewind Aviation Management LLC · Oxford, GAN310LEJones Kent D · St George, UTN310LGCccp LLC · Mustang, OKN310LMMoore Alton · Lago Vista, TXN310LRCasavia Corp · Guelph OntarioN310LTCarrer Aviation LLC · Coshocton, OHN310LWMy Way Aviation LLC · Weston, FLN310MBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN310MCEcolift Corp · San Juan, PRN310MDPbh Investments LLC · Wichita, KSN310MHLawrence Jack C Jr · Saint Augustine, FLN310MKBuchanan Ryan M · Lizella, GAN310MLInternational Air Services Inc Trustee · Carson City, NVN310MMSuhay Richard Trustee · Redlands, CAN310MNMid-Continental Aviation LLC · Wilmington, DEN310MSConway Completions LLC · Conway, ARN310MTEriksson James Daniel · Loudon, TNN310NWatkins Bob H · Huntington Beach, CAN310NDMoroney Aviation LLC · Chugiak, AK
Back to AD 90-02-13